Results 1 to 3 of 3

Thread: Execute As

  1. 06-06-2008, 10:37 AM #1
    bobbo's Avatar
    bobbo
    bobbo is offline Registered User
    Join Date
    Oct 2005
    Location
    Ireland
    Posts
    92

    Execute As

    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?
    Reply With Quote Reply With Quote
  2. 06-06-2008, 01:53 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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
    Reply With Quote Reply With Quote
  3. 06-06-2008, 01:53 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Also this SQL 2005 feature not SQL 2000.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules