From: | csy(at)hjc(dot)edu(dot)sg |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Q about access control and others |
Date: | 1999-01-13 20:16:10 |
Message-ID: | 369c8e8a.1468.0@hjc.edu.sg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello everyone!
I have just installed the a/m on my RedHat Linux 5.2 system and is trying out the
security aspects of the program and couldn't quite figure something out.
Maybe someone can help me with my problems? I installed all the postgresql .rpms
files that came with the RHL 5.2 .
Bascially, the question is how can I protect my database. I tried the following :-
1) createdb test
2) createuser user1
3) createuser user2
4) psql -h dbsvr -d test -u
Both user1 and user2 are able to access the db called test. How can I prevent user2
from being able to access the db?
Also, is the files in the template directory which is copied over to the test directory
necessary for operation of every new database that is created?
Last but not least, is there anyway I can list out the database users that have been
created on the system?
Thanks in advance!
From | Date | Subject | |
---|---|---|---|
Next Message | csy | 1999-01-13 20:17:36 | RPMS for PostgreSQL 6.4.2? |
Previous Message | Lance | 1999-01-13 19:57:35 | subscribe |