Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

schemas Expand / Collapse
Author
Message
Posted Friday, May 17, 2013 5:36 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 5, 2014 6:19 PM
Points: 20, Visits: 165
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.
Post #1454212
Posted Monday, May 20, 2013 7:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 12,946, Visits: 12,355
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1454543
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse