SQL Server/T-SQL Tutorial/System Functions/sp RevokeDbAccess
A statement that revokes access to a database for a SQL Server login ID
EXEC sp_RevokeDbAccess JohnDoe
A statement that revokes access to a database for a Windows user account
EXEC sp_RevokeDbAccess [Accounting\SusanRoberts]