System Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. System Functions
  4. System stored procedures for creating and deleting user-defined roles
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'