Post reply

SQL 2005 Role to see database objects?

  • January 20, 2010 at 9:18 am

    #229266

    Hello all and thank you for your help. I would like to give my IT team the ability to use SQL Management Studio to view stored procedures, views, functions, tables in staging but not have the ability to update anything. Right now they have db_datareader on that database but in studio nothing shows up in the stored procedure folder. Is there a role that can do this?

    Thanks,

    Sunshine

  • January 20, 2010 at 9:22 am

    #1106123

    VIEW ANY DEFINITION would give them the ability to see proc code, but not edit it; here's some examples: you can also do it to a specific schema, so a user can see the definitions of the "UAT" schema, for example.

    GRANT VIEW DEFINITION ON MyProc TO SomeUser

    or GRANT VIEW DEFINITION ON Schema myuserschema TO SomeUser

    Grant View Any Definition To MyUserGroup

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 20, 2010 at 10:36 am

    #1106196

    Perfect and Thanks!

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

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