Granting permissions to create procedure

  • Guys,

    I am facing one issue, the situation is I have many user in the database accessing one db XYZ.

    A group of some users have only read, write (db_readwrite role) permission whereas other user has db_read permissions.

    Now i ahve to give permission to some users from db_readwrite to create, alter, drop procedure.

    I tried with GRANT CREATE PROCEDURE TO <>... but its not working.

    Let me know any aleternate way.

    The goal i want to achive is to give only create procedure permission to the user.

    Thanks.

    Abhijit - http://abhijitmore.wordpress.com

  • Hi

    Grant them ddladmin access to the db which is only going to allow them to run ddl statementes like Create,Alter and drop

  • I have already done this but this allows user to create other objects also. I want to restrict the user upto create procedure permission level.

    Abhijit - http://abhijitmore.wordpress.com

  • Hi

    What will the user do inside the procedure? Thats what you should look into and grant permissions accordingly.

    You can consider using schemas. You can grant the user the rights to create/alter etc only the specific schema. This adds complexity to the database design so may not be a solution for your needs.

    "Keep Trying"

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

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