Hi, can you please guide me as to how can I create users that can only
log on to certain databases.

Thanks for all your help,
Undbund

undbund <undbund (AT) gmail (DOT) com> writes:

Privileges are assigned by a combination of (permission, object, role).
Use the ‘GRANT’ command to give, and the ‘REVOKE’ command to take away,
the permissions you want each account to have to each object.
<URL:http://www.postgresql.org/docs/current/static/sql-grant.html>

--
\ “You can't have everything; where would you put it?” —Steven |
`\ Wright |
_o__) |
Ben Finney

undbund <undbund (AT) gmail (DOT) com> wrote:
Read (and edit) your pg_hba.conf, it is well documented.


Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net