Re: creating users per database

Hello,

I don't think you can create users *inside* a database, but for each
database,
you can create global users and make them members of a group having the same
name than your database.

Then, in pg_hba.conf, the folllowing line will give to your users the
permission to
connect to the database they belong :

host samegroup all 0.0.0.0 0.0.0.0 md5

Bye,
Philippe Ferreira.

>Hi all,
>
>I have a faint memory of it being possible to create users
>"inside" *one* given database by way of a particular "create
>user" syntax along the lines of:
>
> create user newuser(at)thisdb ...;
>
>or similar.
>
>Was this ever possible in PostgreSQL or is my memory playing
>tricks on me ? I went back through the manuals all the way
>to 6.5 and searched archives.postgresql.com/Google, alas, to
>no avail.
>
>I am aware that I can (and should) restrict users to
>databases by way of pg_hba and friends.
>
>Karsten
>
>