Statements that delete the new role : sp_DropRoleMember « System Functions « SQL Server / T-SQL Tutorial






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








25.36.sp_DropRoleMember
25.36.1.The syntax for sp_DropRoleMember
25.36.2.A statement that removes a user from a database role
25.36.3.Statements that delete the new role