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>