CREATE ROLE

Creates a new database role in the current database.

Syntax

CREATE ROLE role_name  [;]

Arguments

role_name

Is the name of the role to be created.

Permissions

Requires CREATE ROLE permission on the database or membership in the db_securityadmin fixed database role.

Examples

Create the database role buyers.

CREATE ROLE buyers;