March 4, 2013 at 12:04 pm
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?
March 4, 2013 at 12:17 pm
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
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply