Table Design In Read Only Mode?

  • I have a user that needs to be able to see table designs, but I'd like to do it in a read-only fashion. Is there a role I can assign her that will do this? None were apparent, at least to me.


    I Only Work Here......

  • Role db_datareader will allow read-only access, but he will be able to see data as well. You don't say if he may see data.

    There are a lot of views of Information_Schema owner that produce information about the database structure. For example

    use Pubs

    select * from information_schema.tables

    You may try to use those setting appropriate permissions.

    Another option is to generate SQL script for the user or supply her/him with the database designer tool like ERstudio or Embarcadero. Set up this user as db_datareader in the designer tool and make sure they use this login only through the designer.

    Yelena

    Regards,Yelena Varsha

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

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