• 1-888-289-2246
  • 24x7x365 Presence

Block listing of databases for users without access.


All SQL logins are members of the ‘public’ server-level role, which by default has the VIEW ANY DATABASE permission. This will revoke that permission :

REVOKE VIEW ANY DATABASE FROM public.

Note: This removes the view database from the required login also.

]]>


Leave a Reply

Your email address will not be published. Required fields are marked *