Demo: Customizing Server Roles in SQL Server 2012
This demo shows how to create a user-defined server role in Transact-SQL. In five minutes we'll walk through how to create a role, add members, remove a member, grant permissions to the role and change the role name. Along the way we'll validate the changes we've made using security catalog views.
Principal Consultant, SQLskills