Let's say I have an account at the server level and they have access to database1, database2, and database3 on the server.
If I run
ALTER LOGIN "account_name" DISABLE this will disable the account and they can not access any of the databases on the server.
If I want to disable the account from database2, is the only way to do that by
DROP USER "account_name"? Is there something similar to the server disable that can be done at the database level?