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

about schemas and roles Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 12:04 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 172, Visits: 337
when you open ssms under database you have schema folder that contains yet again many nodes such as db_datareader,db_datawriter etc which are actually roles also available under roles node in database.how this are different
what is the working of roles under schema node in ssms ??
can anyone tell me it's use?
Post #1426394
Posted Monday, March 4, 2013 12:17 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
They are named the same, but they aren't the same. There is a role called db_datareader and there is a schema called db_datareader. This is a holdover from the SQL Server 2000 days when the users in a database were also effectively schemas if they owned any objects. You couldn't separate the two.

Treat the roles as roles and the schemas as schemas. I would recommend not using these pre-generated schemas, however.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #1426404
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse