| From: | "Dan Wilson" <phpPgAdmin(at)acucore(dot)com> |
|---|---|
| To: | <temp6453(at)hotmail(dot)com>, "pgsql general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Permissions |
| Date: | 2001-01-17 07:10:06 |
| Message-ID: | 010501c08054$85f5a390$078353d8@danwilson |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Diehl, Jeffrey | 2001-01-17 07:41:26 | RE: [SQL] Query from multiple tables... |
| Previous Message | Iwan Tutuka Pambudi | 2001-01-17 06:52:39 | Re: >>>>> pg_dump in crontab |