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?

  • September 25, 2013 at 5:04 am

    #1653064

    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.