SQL Server/T-SQL Tutorial/System Functions/sp AddRole

A statement that creates a new user-defined role

   <source lang="sql">

EXEC sp_AddRole BillingEntry</source>

System stored procedures for creating and deleting user-defined roles

   <source lang="sql">

The syntax for sp_AddRole sp_AddRole [@rolename = ] "role_name"

        [,[@ownername = ] "owner_login_ID" ]

The syntax for sp_DropRole sp_DropRole [@rolename = ] "database_role_name"</source>