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;