This can somewhat be accomplished by editing your pg_hba.conf file. You can
set the database as "sameuser" and it will only allow access to the database
with the same name as the user.
Check here for more details:
http://www.postgresql.org/devel-corner/docs/admin/client-authentication.htm
-Dan
-----------------------
I am setting up a multi-user systme and am looking to set up PostgreSQL
securely for multiple users.
How can I set up PostgreSQL so that people can securely access only
databases they created (such as in mysql database permissions) and not be
able to view/access/create tables in other peoples databases.
Anyone know?
I'd be looking for the SQL calls to do as well, as I am new to SQL
--
Mike