How to assign a user to a database role : sp_addrolemember « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_addrolemember
The syntax for sp_AddRoleMember
sp_AddRoleMember [@rolename = ] 'database_role_name',
                 [@membername = ] 'security_account'








25.20.sp_addrolemember
25.20.1.How to assign a user to a database role
25.20.2.A statement that assigns a user to a database role
25.20.3.Statements that assign users to the new role
25.20.4.A statement that assigns the new role to a fixed database role
25.20.5.Add role member