User defined server roles in SQL Server 2012
In this post I would like to talk about a new security enhancement that was introduced in SQL Server 2012,user defined server roles.As we all know we had (and still have in SQL Server 2012) user defined database roles for database level permissions.In the latest version of SQL Server we can have custom – user defined server roles for server level permissions.Basically for a server-level principal we can grant server-level permissions with a mix of GRANT and DENY permissions. (
read more)