Question 13


Answer D is correct. When an EXECUTE AS statement is run, the execution context of the session is switched to the specified login or username. sp_change_users_login maps an existing database user to a SQL Server login. Auto_Fix links a user entry in the sysusers table in the current database to a SQL Server login of the same name. Update_One links the specified user in the current database to an existing SQL Server login. The username and login must be specified. The password must be NULL or not specified.

For more information, see the following sources:

  • Chapter 3, "Implementing Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Security Considerations for Databases and Database Applications, Context Switching, Extending Database Impersonation by Using EXECUTE AS"




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net