- Plesk for Windows
MS SQL database user is able to see MS SQL database names which are not owned by him.
Default behavior. This issue should be addressed to Microsoft as the provider of SQL Server.
To revoke the permissions, do the following:
- Connect to the server via RDP.
- Open SQL Server Management Studio either locally, or via remote connection. Or use any web admin like MyLittleAdmin to access the database(Plesk > Tools & Settings > Database Servers - Web admin)
- Select "master" database from the list of databases. Once the database is selected, click the button "New Query".
- Run the following SQL query:
CONFIG_TEXT: USE master;
GO REVOKE VIEW ANY DATABASE TO PUBLIC;
Please note that "MASTER" and "TEMPDB" databases will always be visible to all users. It is not possible to make them invisible.