Execute As

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 11 Oct 2013 06:00:00 UT Indexed on 2013/10/24 22:02 UTC
Read the original article Hit count: 118

Filed under:

Learn how you can use Execute As in a stored procedure to control permissions. This article includes an example that limits access to encryption routines for users.

sqlmonitor Optimize SQL Server performance
“With SQL Monitor, we can be proactive in our optimization process, instead of waiting until a customer reports a problem,” John Trumbul, Sr. Software Engineer. Optimize your servers with a free trial.

© SQL Server Central or respective owner