EXECUTE AS sa

Question

Post reply

EXECUTE AS sa

Viewing 3 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: 10143 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