db role

Last Post 24 Jun 2011 08:19 AM by PaulMcKibben. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
01 Mar 2011 08:27 PM
i have db role i want to allow selec/reaad only access

so i created role, added users and check select check box

My question is: is it enough? or shoul di explicitely check under "Deny" deny - alter, deny_delete etc.

thanks
rm
New Member
New Member

--
02 Mar 2011 06:22 AM
You can use builtin role db_datareader.
dbandee
New Member
New Member

--
04 Mar 2011 10:15 AM
have a need to cherry pick some tables
rm
New Member
New Member

--
04 Mar 2011 10:17 AM
Don't need explicitely check other permissions.
PaulMcKibben
New Member
New Member

--
24 Jun 2011 08:19 AM
If you need to grant read access to only certain tables, I would suggest creating a new role with permissions to the tables that your clients need access to like you have. The only issue that I can think of is that your clients maybe in another role that gives them other permissions.


Acceptable Use Policy
---