Printed 2015/11/29 07:58PM

Creating and Managing User-Defined Roles in SQL Server 2012


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

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