Blog Post

Demo: Customizing Server Roles in SQL Server 2012

Sign in to queue

Description

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.

Joe Sack

Principal Consultant, SQLskills

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents