SQL Server/T-SQL Tutorial/System Functions/sp DropRoleMember
A statement that removes a user from a database role
<source lang="sql">
EXEC sp_DropRoleMember db_owner, JohnDoe</source>
Statements that delete the new role
<source lang="sql">
EXEC sp_DropRoleMember BillingEntry, JohnDoe EXEC sp_DropRoleMember BillingEntry, [Accounting\JaneSmith] EXEC sp_DropRole BillingEntry</source>
The syntax for sp_DropRoleMember
<source lang="sql">
sp_DropRoleMember [@rolename = ] "database_role_name",
[@membername = ] "security_account"</source>