Users can see each others' databases?
От | Terry Letsche |
---|---|
Тема | Users can see each others' databases? |
Дата | |
Msg-id | 1095806852.11321.17.camel@localhost.localdomain обсуждение исходный текст |
Список | pgadmin-support |
Hi. I'm using PostgreSQL for a database course. Each user has their own database on the system. Each database is named the same as the user's user name, and pg_hba.conf is set to require sameuser and a password. Using pgadmin3 1.2.0 b1 and PostgreSQL 7.4.3 on Fedora Core 2, when a user connects to their database and browses down the hieararchy, they can "see" all the other user databases, and browse the list of tables, etc. They can even see the contents of other user's tables! Surmising that this was a result of the public schema, I revoked all rights to public for the public schema in each database. This partly works in that I'm able to not see the contents of other users' tables, but I can still get a list of table names, and other information at that level. I'm guessing that I'm overlooking something obvious here. What do I need to do so that users can't see anything from the other users in pgadmin3? Or, if that's not possible, what can be done to minimize this problem? Thanks. Terry
В списке pgadmin-support по дате отправления: