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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
