Thread: Has every postgreSQL database own users?
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? 10x Stanimir
Attachment
> 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@gdansk.sprint.pl * *
-----------------------------------------------------------------*****----------
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@gdansk.sprint.pl * * > -----------------------------------------------------------------*****----------
Attachment
>
> 10x for reply
>
> OK, but every database has pg_user table. Why this table is there?
>
> Remigiusz Sokolowski wrote:
>
pg_user is some kind of view on table pg_shadow - this is like with
passwords in Linux and some other Unixes - in pg_user You have name of
user, his privileges, but not passwords - check it. Besides this view is
also shared between all databases.
Rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * *
-----------------------------------------------------------------*****----------
> > OK, but every database has pg_user table. Why this table is there? > They don't have their own copy. The pg_user (and pg_shadow) table are shared between all databases (think of it as that every database has a symlink to the 'global' pg_user table). Maarten -- Maarten Boekhold, boekhold@tibco.com TIBCO Finance Technology Inc. The Atrium Strawinskylaan 3051 1077 ZX Amsterdam, The Netherlands tel: +31 20 3012158, fax: +31 20 3012358 http://www.tibco.com