May 24, 2002 at 3:24 pm
I'd like to know if their is a way to permit a user to view the underlying table structures of a database without giving them rights to modify anything. I have a user who needs to know the design but can't be allowed to change it.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
May 24, 2002 at 5:52 pm
select rights will give them the structure. Not sure about FKs, Rules, defaults, etc.
Steve Jones
May 26, 2002 at 6:19 pm
In order for our QA department to be able to script databases and nothing more, we put their group in the db_datareader database role. The equivalent of giving them SELECT permissions as Steve indicated. It does allow them to script the FKs and everything else.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply