Home Forums SQL Server 2008 Security (SS2K8) Read-only access to data AND database design? Can it be done? RE: Read-only access to data AND database design? Can it be done?

  • October 21, 2013 at 3:19 pm

    #1660310

    MarkThornton (9/25/2013)

    The answer seems to be as follows:

    1) In Login Properties, click on Securables

    2) Choose the relevant Server as a Securable

    3) grant my colleague the Permission to "view any definition"

    This seems to let him see the design of tables, views and Stored Procedures.

    Not sure if this helps but you can also set this at the database level if you want to make this access more granular.