From: | "Arcadius A(dot)" <ahouans(at)sh(dot)cvut(dot)cz> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Help with privilege or pg_hba.conf |
Date: | 2003-07-19 19:04:21 |
Message-ID: | bfc4ln$apl$1@main.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hello!
I have a Unix box running PostgreSQL 7.3.3.
So far, I have been the only one user of the DB server...and I didn't have
any problem using it with the JDBC driver.
Now, a friend of mine wants to use the DB too for doing web stuffs(PHP,
JSP).... so I need to create a new user on PostgreSQL. this has been done
easily.
Now, I don't want the new user (his username is "cool",and he has a
password ) to access other DBs on my server... I want him to access ONLY a
database named "cool" that he owns
(as user "cool", I have created the DB "cool"... and I want user "cool" to
access ONLY DB "cool" and do any operation on it).
How can this be done?
I've been trying to modify "pg_hba.conf" but with no luck .... as user
"cool", after I connect to the DB server via psql and I do "\c anotherdb",
user "cool" can still connect to "anotherdb".
my "pg_hba.conf" can be found at http://ahouans.sh.cvut.cz/pg_hba.txt
Thanks in advance.
Have a nice weekend!
Arcadius Ahouansou.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-20 04:52:01 | Re: initdb fails after installation on Mac OS X 10.2.6 |
Previous Message | Andrew Biagioni | 2003-07-19 13:27:34 | Re: Database growth problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gould | 2003-07-19 19:19:22 | Re: Cywin? Or wait for 7.4 and Windows port? |
Previous Message | Thomas Kellerer | 2003-07-19 18:58:15 | Re: Cywin? Or wait for 7.4 and Windows port? |