SanDroid (7/22/2011)
crafdenberg (7/22/2011)
Execute as user is made up? It actually does exist but my guess was that it couldn't be used when executing policies.BOL reference:
Execute As (Transact-SQL)
Uh Oh... maybe I spoke to soon. I totaly missed the explination saying this was made up.
"Execute As" is definately a real thing! 😉
"Execute As" is also definately not a permission! :w00t:
You might be able to use this to test the Policy Alert if the User supplied has the ALTER TRACE permission. I realy have no way to test at this time.... 😎
Did you try this crafdenberg? If you can post some working script it would prove your point, but it would not make this command a permission. :hehe:
But since the question is asking for minimum permission "execute as" is not a permission and thus an invalid choice. 'Execute as' is an execution context.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events