EXECUTE AS sa

Question

Post reply

EXECUTE AS sa

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
April 26, 2016 at 10:14 pm

#77476

Comments posted to this topic are about the item EXECUTE AS sa
April 27, 2016 at 12:53 pm

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

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

Revenant SSC-Forever Points: 42467 More actions · Answer 1

Not many attempts... Interesting.

Thanks, Steve!

edit: typo

George Vobr SSChampion Points: 10009 More actions · Answer 2

Thanks for this question Steve. Today I had to do with the question of a hard time, really dangerous.:-) Eventually helped me this article, which confirms that it is dangerous:

http://dbaspot.com/ms-sqlserver/231843-how-grant-impersonate-dbo-permissions.html

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I don't like granting impersonate, but the EXECUTE AS comes in very handy sometimes.

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