Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

Managing User-Defined Database Roles

USE YourDatabaseName GO CREATE ROLE YourRoleName AUTHORIZATION db_owner GRANT SELECT ON YourTableName TO YourRoleName EXEC sp_addrolemember 'YourRoleName', 'YourName' GO ALTER ROLE YourRoleName WITH NAME = YourRoleNameNew DROP ROLE YourRoleNameNew EXEC sp_droprolemember 'YourRoleNameNew', 'YourName' GO DROP ROLE YourRoleNameNew