This topic has not yet been rated - Rate this topic

Create a User-Defined Role

SQL Server 2012

Open SQL Server Management Studio.
Click Object Explorer on the View menu.
On the Object Explorer toolbar, click Connect, and then click Database Engine.
In the Connect to Server dialog box, provide a server name and select an authentication mode. You can use a period (.), (local), or localhost to indicate the local server.
Click Connect.
Expand Databases, System Databases, msdb, Security, and Roles.
In the Roles node, right-click Database Roles, and click New Database Role.
On the General page, provide a name and optionally, specify an owner and owned schemas and add role members.
Optionally, click Permissions and configure object permissions.
Optionally, click Extended Properties and configure any extended properties.
Click OK.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions