Creates a new role, extends an existing user to act as a role, or manages role administrators on a role.
CREATE [ OR REPLACE ] ROLE role_name | FOR USER userID [ WITH ADMIN [ ONLY ] admin_name [,...] ]
CREATE ROLE Sales
CREATE OR REPLACE ROLE FOR USER Jane
CREATE ROLE Finance WITH ADMIN ONLY Mary, Jeff
CREATE OR REPLACE ROLE Finance WITH ADMIN Bob, Sarah
ANSI SQL – Compliance level: Transact-SQL extension.