Post reply

User Permission

  • November 15, 2010 at 4:47 pm

    #228802

    Hello Everyone

    I am trying to figure out a way to grant a SQL User, db_DataReader Access, but also allow the user to see the list of Stored Procedures / Views. Is there a way?

    Thank you in advance

    Andrew SQLDBA

  • November 15, 2010 at 5:02 pm

    #1251055

    This should do the trick assuming the views and sprocs you want them to see are all in the dbo schema.

    GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [sqluser]

    GO

  • November 16, 2010 at 8:26 am

    #1251370

    Sweet, thank you

    I will give that a try.

    Andrew SQLDBA

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

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