Post reply

Granting Security to Create Stored Procedures

  • October 2, 2006 at 7:59 am

    #170527

    I am having trouble granting the necessary security to a developer so he can create stored procedures.

    He gets this error when trying to create He gets this error when trying to create the store procedure.

    The specified schema name "dbo" either does not exist or you do not have permission to use it.

    So far I granted his id Create Procedure, View Definition, Execute, db_datareader, db_datawriter.

    Any id what I need to grant to allow them to create stored procedures for dbo?

     

     

     

    David Bird

  • October 3, 2006 at 9:02 am

    #663857

    GRANT ALTER SCHEMA :: dbo TO developerUserName

    This grants the developer permission to create, alter or drop any database ojbect in the dbo schema. I don't think there's anything less restrictive that still allows creation of objects in dbo schema.

    Your other option is to create a schema for the developer to use while developing and then transfer the finished procedures to dbo ownership (as dbo user).

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

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