Postgres Pro
Downloads
Home   >   mailing lists

Thread: Database Security

Database Security

From
Kalai R
Date:
hi,

i am near to PostgreSql. I create a database by the superuser. Then i create another logon user. Now  how can i protect my database from the new user. i want to ban the access and view the database to the new user.It can done by an entry in pg_hba file. Is there any other way to secure my database(like setting password)?. Please help to solve my problem.

Re: Database Security

From
"Albe Laurenz"
Date:
Kalai R wrote:
> i am near to PostgreSql. I create a database by the
> superuser. Then i create another logon user. Now  how can i
> protect my database from the new user. i want to ban the
> access and view the database to the new user.It can done by
> an entry in pg_hba file. Is there any other way to secure my
> database(like setting password)?. Please help to solve my problem.

Since PostgreSQL 8.3:

REVOKE CONNECT ON DATABASE dbname FROM PUBLIC;
GRANT CONNECT ON DATABASE dbname TO user1, user2, user3;

Yours,
Laurenz Albe