Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

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'