EXECUTE AS procedures

Question

EXECUTE AS procedures

Steve Jones - SSC Editor

SSC Guru

Points: 734459
More actions
January 31, 2016 at 12:30 am

#315457

Comments posted to this topic are about the item EXECUTE AS procedures
January 31, 2016 at 10:41 pm

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

The good thing about this question; that it made me do some R&D to know the answer which had me gained some new & useful info, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 2

palotaiarpad

SSCertifiable

Points: 5617

February 1, 2016 at 1:17 am

#1855620

Shame on me! Session is not equal procedure! :blush:

Rune Bivrin SSCrazy Eights Points: 8441 More actions · Answer 3

It's somewhat interesting that the topic cited for reference disagrees a great deal with this:

MSDN EXECUTE (Transact-SQL)

Aah! Now I see it. Not specified when executing the SP, but when creating the SP. Different.

Now for some coffee!

Just because you're right doesn't mean everybody else is wrong.

MG-148046 SSCrazy Eights Points: 9946 More actions · Answer 4

May be a problem with the web page. I checked the 4 correct answers and got an incorrect.

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

TomThomson SSC Guru Points: 104773 More actions · Answer 5

ARGHHH! Create not execute!!!!

I'm in careless mode tonight (eldest son just pointed me at robozzle.com, which I hadn't seen before, result is that I'm temporarily unable to do anything serious, or even something not quite serious like QotD).

Tom

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 6

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287024 More actions · Answer 7

Personally, I love the EXECUTE AS both when creating procedures and also to impersonate to troubleshoot permissions. Good question.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

Hany Helmy (1/31/2016)
The good thing about this question; that it made me do some R&D to know the answer which had me gained some new & useful info, thanx.

Me too.