Statements that assign users to the new role : sp_addrolemember « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_addrolemember
EXEC sp_AddRoleMember BillingEntry, JohnDoe
EXEC sp_AddRoleMember BillingEntry, [Accounting\JaneSmith]








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