Permissions: GRANT, DENY, REVOKE (Azure Synapse Analytics, Analytics Platform System (PDW), Microsoft Fabric) Server level permissions are applied to logins. Database level permissions are applied to ...

You just need to double click the account in SQL Server, go to Securables, and simply uncheck the GRANT. Here is what you will see when using the GUI to remove the CONNECT permission.

Is there something in SQL server that I need to change so the user can be "seen" or added to the other database? Both databases are on the same server and I'm using SQL Server 2008.<BR><BR>Any ...