Database Security
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.
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