REVOKE VIEW ANY DATABASE TO Public

This command will stop users to view the Databases which are all existing in that particular server.
REVOKE VIEW ANY DATABASE TO Public
And want to give permission to the users(Other Logins) to see the database run this below command.
GRANT VIEW ANY DATABASE TO Public

Thanks
Ramesh.M

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server