Re: Revoking usage of pg_catalog - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Revoking usage of pg_catalog
Date
Msg-id 1178733179.7497.54.camel@state.g2switchworks.com
Whole thread Raw
In response to Revoking usage of pg_catalog  ("Daniel Cristian Cruz" <danielcristian@gmail.com>)
Responses Re: Revoking usage of pg_catalog  ("Daniel Cristian Cruz" <danielcristian@gmail.com>)
List pgsql-admin
On Wed, 2007-05-09 at 08:05, Daniel Cristian Cruz wrote:
> Hi there!
>
> Is it possible to revoke usage of pg_catalog for a specific user?
>
> The reason is to secure PostgreSQL. If a user can connect to a
> database, it could query pg_class, pg_attribute, pg_proc search for
> specific tables and if using dblink, even database passwords...

That's not security, it's obscurity.

You can grant / revoke access to anything a user should or should not be
able to access anyway.



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Revoking usage of pg_catalog
Next
From: "Daniel Cristian Cruz"
Date:
Subject: Re: Revoking usage of pg_catalog