Post reply

User permission only for Stored Procedures

  • May 9, 2007 at 8:42 am

    #116794

    Hi,

    I need to create a user on SQL Server 2005, who need to work only with stored procedures (Full access to Store Procedure creating, deleting, alter, execute)

    Can anyone please send a script or link on the same.

    Thanks

    Pavan

  • May 9, 2007 at 9:12 am

    #705259

    Pavan

    This page from Books Online should get you started:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c001c2e7-d092-43d4-8fa6-693b3ec4c3ea.htm

    I'm a bit concerned, though, that if the user who creates the procedure doesn't have access to the objects in the stored procedures, you may have problems.  I've never tried it out like that so I can't really say how difficult it's going to be.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply