Thread: Permissions
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
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