Justin Camp wrote: > Greetings! > > I apologize if this has been previously posted.. > > I run a server with multiple clients running databases on one server, > and I was wondering if there was a way to limit the list all databases > function within the pgsql program to only list databases within a > criteria, say, what they have permission to see? > > Or perhaps, if that is not possible, a way to shut off the > functionality entirely, from the server side?
It is not possible. pg_database is a global table, visible to all databases. I can't think of a way to limit such visibility. Perhaps you can create a pg_database in the public schema and have it only return the current database and template1. That might work, or it might not, but the pg_database will still be visible in pg_catalog. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]