January 10, 2012 at 12:49 pm
Hi,
I am new Sql Server. Just started reading abt the security part in sql server. I have a question regarding it.
Q1- What excatly is a role?
Q2-= If I assign a login as SECURITYADMIN. Wil he be able to manage all the logins(I mean Both Sql Logins and Windows Logins)? Or Will be able to manage only Sql Server Logings?
Can any one elobatre on Roles?
Thank You
January 10, 2012 at 1:22 pm
Role - Group in AD. It's a way of assigning permissions to an object, and then assigning particular users to the role/group and having them receive permissions.
In terms of securityadmin - http://msdn.microsoft.com/en-us/library/ms189610%28v=SQL.90%29.aspx
It manages both Windows and SQL logins.
January 10, 2012 at 2:42 pm
I read in a book that "Server roles are Static Objects"
What do Static Objects mean?
January 10, 2012 at 2:50 pm
Not sure, maybe one that can't be customized. You can't change rights on a server role.
January 10, 2012 at 3:26 pm
nawaz1774 (1/10/2012)
I read in a book that "Server roles are Static Objects"What do Static Objects mean?
They can't be changed (and in 2008 R2 and below, can't be added to either)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply