CODE EXAMPLE FOR SQL

revoke a role from user microsoft sql server

ALTER ROLE roleName DROP MEMBER UserName;