SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, Execute AS Rss

   Items 1 to 2 of 2   

EXECUTE AS procedures

By Steve Jones 2016/02/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,551 reads

Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005

In a previous tip on Switching Execution Context using the REVERT clause, you have seen how to switch execution context to a more privileged user and revert back to the original context of the caller within a programmable object. The REVERT clause accepts a parameter WITH COOKIE to provide an even more granular option. How do we use it?  Read more...
By Additional Articles 2009/01/15 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 2,945 reads
   Items 1 to 2 of 2   
security (2)    
revert (1)