A crummy but workable solution is to have each user install and run their own instance of PostgreSQL. On the other hand, learning to install and configure a major database is probably a useful learning experience. --Rick
Andreas Pflug
<[EMAIL PROTECTED] To: Cheetah <[EMAIL PROTECTED]>
e> cc: [EMAIL PROTECTED]
Sent by: Subject: Re: [pgadmin-support]
Users can see each others' databases?
[EMAIL PROTECTED]
tgresql.org
09/22/2004 02:59 AM
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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
