Easy question about setting permissions

[zoey4zoey@yahoo.com]

Hi,
is there a way to set permissions on a database so that a certain user can view the design of all the tables, sps and triggers etc but not be able to view the data. If so, how do you do that?
thanks
Zoey

[Mohammed.]

Create the login 'abc' and user in the database 'abc' and deny the user for db_datareader and db_datawriter...
User can see the schema of the tables and SP by using sp_help and sp_helptext but I am not sure he can see from EM...

Mohammed....


------------
zoey4zoey@yahoo.com at 12/19/2001 12:33:10 PM


Hi,
is there a way to set permissions on a database so that a certain user can view the design of all the tables, sps and triggers etc but not be able to view the data. If so, how do you do that?
thanks
Zoey