SQL Server Performance

Granting permissions to view stored procedures

Discussion in 'SQL Server 2005 General DBA Questions' started by silktaiji1, Sep 7, 2007.

  1. silktaiji1 New Member

    I need to grant permissions to a login, and the login only needs to view stored procedures (contents not just names of SP's). I don't not want to grant him db_owner nor ddladmin roles. I granted him execution privilege, but he can only sees names of SP's not scripts.
    Any input will be helpful. Thanks.
  2. ghemant Moderator

  3. satya Moderator

    To view the text within the SQL 2005 you need to grant them VIEW DEFINITION on the procedures. To make it simpler you grant them this permission on the schema:

    GRANT VIEW DEFINITION ON SCHENA::dbo TO someuser

Share This Page