locked
Privillage required to execute the stored procedure RRS feed

  • Question

  • I have created a user who has db_ddladmin privillage in SQL server 2008. In this case, the user is able to create tables, indexes and stored procedure. The user is unable to execute the stored procedure when he create a new stored procedure unless we explicitly grant the execute privilage to the same user even though he is the owner of the procedure.

    There are two options avilable
    1) Granting DBO privillage - I prefer not to grant this privilage to the users
    2) Running the execute maually or via scripts - This may not be a good idea.

    In SQL server 2005, we use "grant all to <USER>". This is depecated in SQL server 2008.

    Do you have any suggestion?

    Thanks
    Senthil

    Tuesday, July 28, 2009 11:09 PM

Answers




  • Use Like this may help you

    Use DatabaseName

    GO

     

    GRANT EXECUTE TO UserName



    Aamir

    Wednesday, July 29, 2009 9:27 AM

All replies




  • Use Like this may help you

    Use DatabaseName

    GO

     

    GRANT EXECUTE TO UserName



    Aamir

    Wednesday, July 29, 2009 9:27 AM
  • Thanks Aamir. I will test it.
    Thursday, July 30, 2009 4:24 AM