pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRevoking usage of pg_catalog
5+ messages / 4 participants
[nested] [flat]
* Revoking usage of pg_catalog
@ 2007-05-09 13:05 Daniel Cristian Cruz <danielcristian@gmail.com>
2007-05-09 14:52 ` Re: Revoking usage of pg_catalog Tom Lane <tgl@sss.pgh.pa.us>
2007-05-09 17:52 ` Re: Revoking usage of pg_catalog Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 2 replies; 5+ messages in thread
From: Daniel Cristian Cruz @ 2007-05-09 13:05 UTC (permalink / raw)
To: pgsql-admin
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...
I just made a test, revoking usage of pg_catalog from PUBLIC, but tables are
still available through "SELECT * FROM pg_class", but not through "SELECT *
FROM pg_catalog.pg_class". I found in manual, where it says pg_catalog is
searched before any schema on search_path...
If schema pg_catalog became blocked, PostgreSQL could be used? Could it be
possible to made queries on allowed schemas and tables? This could be an
item for the wishlist?
Kind regards,
--
Daniel Cristian Cruz
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Revoking usage of pg_catalog
2007-05-09 13:05 Revoking usage of pg_catalog Daniel Cristian Cruz <danielcristian@gmail.com>
@ 2007-05-09 14:52 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2007-05-09 14:52 UTC (permalink / raw)
To: Daniel Cristian Cruz <danielcristian@gmail.com>; +Cc: pgsql-admin
"Daniel Cristian Cruz" <danielcristian@gmail.com> writes:
> Is it possible to revoke usage of pg_catalog for a specific user?
No, not if you'd like them to be able to do anything useful.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Revoking usage of pg_catalog
2007-05-09 13:05 Revoking usage of pg_catalog Daniel Cristian Cruz <danielcristian@gmail.com>
@ 2007-05-09 17:52 ` Scott Marlowe <smarlowe@g2switchworks.com>
2007-05-09 18:09 ` Re: Revoking usage of pg_catalog Daniel Cristian Cruz <danielcristian@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Scott Marlowe @ 2007-05-09 17:52 UTC (permalink / raw)
To: Daniel Cristian Cruz <danielcristian@gmail.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Revoking usage of pg_catalog
2007-05-09 13:05 Revoking usage of pg_catalog Daniel Cristian Cruz <danielcristian@gmail.com>
2007-05-09 17:52 ` Re: Revoking usage of pg_catalog Scott Marlowe <smarlowe@g2switchworks.com>
@ 2007-05-09 18:09 ` Daniel Cristian Cruz <danielcristian@gmail.com>
2007-05-09 23:47 ` Re: Revoking usage of pg_catalog John DeSoi <desoi@pgedit.com>
0 siblings, 1 reply; 5+ messages in thread
From: Daniel Cristian Cruz @ 2007-05-09 18:09 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
2007/5/9, Scott Marlowe <smarlowe@g2switchworks.com>:
> 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.
Yes, I used the wrong expression.
> You can grant / revoke access to anything a user should or should not be
> able to access anyway.
It's a web application user. I was trying to make some database magic,
hardening SQL injections... But its wrong, the application must be
secure. Unfortunelly I can't have a database user for each web user...
Thanks...
--
Daniel Cristian Cruz
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Revoking usage of pg_catalog
2007-05-09 13:05 Revoking usage of pg_catalog Daniel Cristian Cruz <danielcristian@gmail.com>
2007-05-09 17:52 ` Re: Revoking usage of pg_catalog Scott Marlowe <smarlowe@g2switchworks.com>
2007-05-09 18:09 ` Re: Revoking usage of pg_catalog Daniel Cristian Cruz <danielcristian@gmail.com>
@ 2007-05-09 23:47 ` John DeSoi <desoi@pgedit.com>
0 siblings, 0 replies; 5+ messages in thread
From: John DeSoi @ 2007-05-09 23:47 UTC (permalink / raw)
To: Daniel Cristian Cruz <danielcristian@gmail.com>; +Cc: pgsql-admin
On May 9, 2007, at 2:09 PM, Daniel Cristian Cruz wrote:
> It's a web application user. I was trying to make some database magic,
> hardening SQL injections... But its wrong, the application must be
> secure. Unfortunelly I can't have a database user for each web user...
I don't see the issue if users don't connect directly to the
database, only through your web application. You then have complete
control over any query executed. You should not have to worry about
SQL injection if you use prepared queries and stored procedures.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-05-09 23:47 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-09 13:05 Revoking usage of pg_catalog Daniel Cristian Cruz <danielcristian@gmail.com>
2007-05-09 14:52 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-05-09 17:52 ` Scott Marlowe <smarlowe@g2switchworks.com>
2007-05-09 18:09 ` Daniel Cristian Cruz <danielcristian@gmail.com>
2007-05-09 23:47 ` John DeSoi <desoi@pgedit.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox