http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2012/08/02/creating-and-managing-user-defined-roles-in-sql-server-2012/

Printed 2014/09/19 03:57AM

Creating and Managing User-Defined Roles in SQL Server 2012

2012/08/02

SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference is that they are created by SQL Server Administrator. SQL Administrators can create, delete or manage these user-defined server roles using T-SQL or SQL Server Management Studio. User-defined roles can be added as member of another user-defined or fixed server role. Like SQL Server logins, we can only also assign server-wide permissions to these user-defined server roles.

Checkout my article (ie Creating and Managing User-Defined roles in SQL Server 2012) that discusses how these user-defined roles can be used to simplyfy the administration of SQL Server.

This article is published on SSWUG.org.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.