[ADMIN] %psql help

2006-07-05 Thread KyLiE
Hi all, I'm quiet new in this stuff, I have N psql users and N databases, each user has a database and can connect to it using his psql account, however I don't want to allow that some user access to another database that does not belong to him. I've modify my pg_hba.conf file, and allow the a

Re: [ADMIN] %psql help

2006-07-06 Thread Robin Iddon
Check out the GRANT nd REVOKE commands: http://www.postgresql.org/docs/8.1/static/sql-grant.html http://www.postgresql.org/docs/8.1/static/sql-revoke.html You may want to do some revoking of PUBLIC rights followed by some granting of rights to specific users on specific databases. But, I don'