http://www.sqlservercentral.com/Articles tagged Roles posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article describes how to create user defined server roles and use stored procedures and queries related.

]]>http://www.sqlservercentral.com/articles/Security/89923/Fri, 25 May 2012 06:00:00 UThttp://www.sqlservercentral.com/articles/Security/89923/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.

]]>http://www.sqlservercentral.com/redirect/articles/88749/Wed, 29 Feb 2012 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/88749/This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.

]]>http://www.sqlservercentral.com/articles/Security/76919/Thu, 09 Feb 2012 07:00:00 UThttp://www.sqlservercentral.com/articles/Security/76919/