Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Granting Edit Permission on Stored Procedures

    I have a user on my database that has the following base permissions :


    I need to give this user permission to edit a single stored procedure. I have tried using the following command :

    GRANT ALL ON stored_procedure_name TO username

    Which executes successfully, but the user still cannot edit the stored procedure.

    If I give the user db_ddladmin permission they can edit all the user stored procedures, but for security reasons I would prefer to be able to this this at procedure level rather than a global permission on all user procs.

    Does anybody know how I can do this?

    EDIT : This is on SQL 2000
    Last edited by MrEyes; 01-21-05 at 09:37.

  2. #2
    Join Date
    May 2004
    Does this user have the same permission on some tables which related to this procedure?

Posting Permissions

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