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.

Ashwani Wednesday 12 June 2013 - 7:55 pm | | Default
Used tags: , , , ,

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
« Antispam settings on … | Home | How to Host a Domain … »