Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags Security, impersonation Rss

   Items 1 to 3 of 3   

SQL Server Impersonation

SQL Server impersonation, or context switching, is a means to allow the executing user to assume the permissions of a given user or login until the context is set back, set to yet another user, or the session is ended. Deanna Dicken shows you two mechanisms for accomplishing this task and walks through some examples.  Read more...
By Additional Articles 2010/02/25 | Source: Database Journal | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,122 reads

Context Switching or Database Impersonation using EXEC AS

SQL Server 2005/2008 provides the ability to change the execution and security context with the EXEC or EXECUTE AS clause to allow a user to perform high privileged activities without allowing the user to have high privilege access.  Read more...
By Additional Articles 2009/07/17 | Source: SQL Server Performance | Category: execute as
Rating:  Rate this |   Briefcase | 1,822 reads


By Steve Jones 2009/01/06 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 3,372 reads
   Items 1 to 3 of 3   
execute as (1)