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
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'