CREATE ROLE (TSQL Statement)

creates a new role in the current database.

Syntax

CREATE ROLE role_name

Arguments

role_name

is the role name.

Remarks

Only sa or dbo is allowed to execute this statement.

The command SHOW U displays the list of users (and corresponding login) and roles.

The command SHOW R displays only the list of roles.

Examples

CREATE ROLE accounting;