jenny 12957 (5/17/2013)
hi,I am trying to figure out the schemas for a new database, and im wondering about the best practice for this type of scenario. I have a database, lets call it x. I have two different types of user groups that need to access the x database, but some tables in the database needs to be hidden from one group, but the rest of the tables both groups should be able to access.
You could use schemas to help here but mostly it sounds like all you really need to understand is roles. Each user will be a member of a role. The role that can see all the tables will have that permission, the other role will not be able to see all the tables. Then you just add the appropriate user to the appropriate role.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/