Managing User-Defined Database Roles: grant : Role « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. Role
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








28.9.Role
28.9.1.Some of the SQL Server fixed server roles
28.9.2.Managing Server Role Members
28.9.3.Reporting Fixed Server Role Information
28.9.4.Managing User-Defined Database Roles: grant
28.9.5.Managing User-Defined Database Roles: alter role
28.9.6.Managing User-Defined Database Roles: drop role
28.9.7.Managing Application Roles
28.9.8.Managing Fixed Database Role Membership: sp_droprolemember
28.9.9.Managing User-Defined Database Roles: Create
28.9.10.Reporting Fixed Database Roles Information
28.9.11.Managing Fixed Database Role Membership: sp_addrolemember