If I create a SP with EXECUTE AS OWNER and then I call this SP using user1 (not the owner), does user1 still need execute permission on the SP?
Printable View
If I create a SP with EXECUTE AS OWNER and then I call this SP using user1 (not the owner), does user1 still need execute permission on the SP?
You need to grant IMPERSONATE privilege to the account that calls the stored procedure
-- From BOL --
To specify EXECUTE AS on a login, the caller must have IMPERSONATE permissions on the specified login name. To specify EXECUTE AS on a database user, the caller must have IMPERSONATE permissions on the specified user name. When EXECUTE AS CALLER is specified, IMPERSONATE permissions are not required
Also this SQL 2005 feature not SQL 2000.