Re: [SQL] Has every postgreSQL database own users? - Mailing list pgsql-sql

From Remigiusz Sokolowski
Subject Re: [SQL] Has every postgreSQL database own users?
Date
Msg-id Pine.GS4.4.02A.9902051136180.12691-100000@netra.gdansk.sprint.pl
Whole thread Raw
In response to Re: [SQL] Has every postgreSQL database own users?  (Stanimir Stanev <stancho@macropoint.com>)
List pgsql-sql
>
> 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           * *
-----------------------------------------------------------------*****----------


pgsql-sql by date:

Previous
From: Stanimir Stanev
Date:
Subject: Re: [SQL] Has every postgreSQL database own users?
Next
From: Maarten Boekhold
Date:
Subject: Re: [SQL] Has every postgreSQL database own users?