March 21, 2005 at 9:18 am
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......
March 21, 2005 at 10:02 am
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