- Plesk for Windows
Note: This article has the reference to the issue with the fix available:
- #PPPM-838 "Support issue #PPPM-838"
- Plesk Onyx 17.8 Release 17 April 2018
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;
REVOKE VIEW ANY DATABASE TO PUBLIC;
Note: "MASTER" and "TEMPDB" databases will always be visible to all users. It is not possible to make them invisible.