July 11, 2014 at 6:35 am
How to restrict access to only allow for all tables/views in the .dbo schema ?
July 11, 2014 at 8:36 am
Don't put the user in any fixed database roles and then run something like:
GRANT SELECT ON schema::dbo TO ;
which grants select only on all objects in the dbo schema. Since there are no other permissions granted through other roles the user will only have SELECT permissions on objects in dbo.
If you are going to have multiple users that you want to have the same permissions I'd create a role named something like dboSelectOnly or dboAccessOnly and then run the GRANT to that role instead of a user. Then when adding users assign them to that role.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 11, 2014 at 9:39 am
Vague, can you elaborate as to what you are looking for here?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply