Friday, July 20, 2007

EXECUTE AS clause (TSQL)

"By specifying the context in which the module is executed, you can control which user account the SQL Server 2005 Database Engine uses to validate permissions on objects that are referenced by the module." - BOL

The Options

{ EXEC | EXECUTE } AS { CALLER | SELF | OWNER | 'user_name' }

This applies to create procedure statement:

No comments: