Обсуждение: Database Security

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