MS SQL Server - Access right for Database Role

Author

Access right for Database Role

Peter

2005-04-29, 7:23 am

Hi,

For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?

If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?

Thanks

Narayana Vyas Kondreddi

2005-04-29, 7:23 am

the db_datareader role only allows the user to read tables in the database,
not exec stored procedures. There is no role that grants exec permissions on
all stored procs inside a db. You will have to manually grant them. See if
this helps:

http://vyaskn.tripod.com/ generate_...e_sql_tasks.htm

I have an example at the above link.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

"Peter" < anonymous@discussion
s.microsoft.com> wrote in message
news:ORyFIPKTFHA.3056@TK2MSFTNGP14.phx.gbl...
Hi,

For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?

If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?

Thanks

Sponsored Links