Drop a sql server user from a database role.
sp_droprolemember [ @rolename = ] 'role' ,
[ @membername = ] 'security_account'
GO
--returns 0=ok 1=failed
Adding a database user
The following example drops the database user ericm to the PROD database role.
EXEC sp_addrolemember 'PROD', 'ericm' GO
Collapse All 
Expand All