- Plesk for Windows
MS SQL database user is able to see MS SQL database names which are not owned by him.
This issue should be addressed to Microsoft as the provider of SQL Server.
If you want better security, do the following:
- Log into SQL Server Management Studio either locally, or via remote connection.
- 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.