Creates a new role.

Syntax

---

CREATE ROLE <Name>
[DESCRIPTION <Description>]
[ATTRIBUTES <CustomAttributes>]

Usage

---

Use this statement to create a new role. Roles can be granted privileges and then granted to users. This makes it very quick and easy to modify the privileges for a group of users without being force to modify the privileges for each user individually.

Examples

---

-- The following statement creates a Cashier role.

CREATE ROLE "Cashier"
DESCRIPTION 'Cashier Role'

Required Privileges

---

The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: