Restricting users to certain databases

[undbund]

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

[Ben Finney]

undbund <und...@gmail.com> writes:

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

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

[Andreas Kretschmer]

undbund <und...@gmail.com> wrote:
> Hi, can you please guide me as to how can I create users that can only
> log on to certain databases.

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