Re: [SQL] Has every postgreSQL database own users?

10x for reply

OK, but every database has pg_user table. Why this table is there?

Remigiusz Sokolowski wrote:

> > hi all
> >
> > Has every postgreSQL database own users?
> >
> > for example:
> >
> > If I have databases with name "db1" and "db2". I want to have user
> > "user1" for "db1" and user "user1" (same name, but with other password)
> > for "db2". Is this available?
> AFAIK this is not possible. Users of postgres are stored in table
> pg_shadow and this table is shared between all of databases. I'm not sure
> if this is also in case when You create another database system, but
> suppose that even in this case user must be unique.
> Rem
>
> -------------------------------------------------------------------*------------
> Remigiusz Sokolowski e-mail: rems(at)gdansk(dot)sprint(dot)pl * *
> -----------------------------------------------------------------*****----------