System stored procedures for creating and deleting user-defined roles : sp_AddRole « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_AddRole
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'








25.19.sp_AddRole
25.19.1.System stored procedures for creating and deleting user-defined roles
25.19.2.A statement that creates a new user-defined role