SQL Server Tutorial - Impersonation and EXECUTE AS

SQL Server 2008 DBA Training: Impersonation and EXECUTE AS

We will discuss in this video tutorial how impersonation works using the EXECUTE AS statement. This video will really focus on helping you understand impersonation at a high-level as our next videos will be centered around these fundamentals.

Highlights from this video:

• Security context vs execution context
  
• What can I impersonate and what permissions do I need?
  
• Architecture for the IMPERSONATE permission
  
• Two types of context-switching
  
• Server-level impersonation, database-level impersonation
  

and much more

This video is part of LearnItFirst's SQL Server 2008 Database Administration training course.

Related Links:

• Video detail page
• Course home page
• Free IT Training Videos
• Free Windows Server videos