I'm setting up phppgadmin so that a group of us can collaborate on a database project on a Postgresql server. However, nobody but myself needs access to any of the databases except the target database (I'll call it DB_2). Is there anyway to prevent this?
I have checked the Postgresql docs and don't seem to see anything that would prevent a database from being visible. I do see things that would prevent actions (insert/update/select, etc) and have tried removing all permissions from my databases. I then logged in as an "unprivileged" user (create permissions on DB_2, but none on the other databases), and am able to navigate through the structure of the other databases. Of course, if I try to change anything, I get an access denied message. But, it doesn't seem right to allow the database structure to be viewed like this. Thanks for any tips. Shawn PS. Not sure if it'll help, but the info I did find made reference to the GRANT and REVOKE commands, but the permissions (insert/update/select/etc.) didn't seem applicable to hiding a database from view. _______________________________________________ clug-talk mailing list [EMAIL PROTECTED] http://clug.ca/mailman/listinfo/clug-talk_clug.ca
