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