Saturday, February 25, 2012

Access right for Database Role

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 ?
Thanksthe 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_scripts_repetitive_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@.discussions.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

No comments:

Post a Comment