Disable databse listing for non-superuser (\l) ?

Started by Brian A. Sekleckialmost 17 years ago2 messagesgeneral
Jump to latest
#1Brian A. Seklecki
seklecki@noc.cfi.pgh.pa.us

All:

Any suggestions on how-to, or comments on a potential NFR, to disable
non-superuser's from viewing the database list via \l?

Possibly a postgresql.conf toggle or restrictions on the internal views
that constitute ....say, 'pg_catalog.pg_database'.

Something equivalent, in principal, to FreeBSD sysctl:

% security.bsd.see_other_uids=0

Just a thought...

~BAS

#2Bruce Momjian
bruce@momjian.us
In reply to: Brian A. Seklecki (#1)
Re: Disable databse listing for non-superuser (\l) ?

Brian A. Seklecki wrote:

All:

Any suggestions on how-to, or comments on a potential NFR, to disable
non-superuser's from viewing the database list via \l?

No, not really. If we ever get row-level security, it could be used to
accomplish what you want.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +