Database access

[tnerurkar]

Hi all,

I want to give particular database access to few users and everybody will not able to access that database. how I can grant/revoke the database access?

other users should not access database using "psql". Can I revoke them at this level ?

Regards,
Tushar

 

[stoolpigeon]

The documentation for users and permissions is here:

http://www.postgresql.org/docs/8.0/interactive/user-manag.html

The documentation for client access is here:

http://www.postgresql.org/docs/8.0/interactive/client-authentication.html

Both tools combined will give you a high degree of control over who can do what.