Re: Users can see each others' databases?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Cheetah <fastcat(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Users can see each others' databases?
Date: 2004-09-22 07:59:25
Message-ID: 415130DD.403@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Cheetah wrote:

>
> I suspect that in order to not be able to see other users' tables, you
> must revoke permissions on the pg_catalog schema (and for the
> enterprising users the information_schema schema too I suspect), which
> is where all the views and whatnot that pgadmin queries to list tables
> live. If this is for a course, I'd bet on students being enterprising
> when trying to circumvent access restrictions :)

Cheetah is completely right. Access restrictions on schema information
come up from time to time, without a viable proposal how to implement
it. Won't happen in the near future, and isn't supposed to be critical.

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Kate Burghardt 2004-09-22 17:31:53 No authentication
Previous Message Andreas Pflug 2004-09-22 07:57:33 Re: Hello