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: 165
        
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.
|  | 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