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
