Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Roles Rss

Search for any content tagged roles

   Items 1 to 3 of 3   
 

The User Defined Server Roles in SQL Server 2012

This article describes how to create user defined server roles and use stored procedures and queries related.  Read more...
By Daniel Calbimonte 2012/05/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,515 reads

New User-defined Server Roles in SQL Server 2012

SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.  Read more...
By Additional Articles 2012/02/29 | Source: Database Journal | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,439 reads

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...
By Eric Russell 2012/02/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,574 reads
   Items 1 to 3 of 3