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

From: Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl>
To: Stanimir Stanev <stancho(at)macropoint(dot)com>
Cc: "pgsql-sql(at)hub(dot)org" <pgsql-sql(at)hub(dot)org>
Subject: Re: [SQL] Has every postgreSQL database own users?
Date: 1999-02-05 10:38:18
Message-ID: Pine.GS4.4.02A.9902051136180.12691-100000@netra.gdansk.sprint.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Maarten Boekhold 1999-02-05 10:43:15 Re: [SQL] Has every postgreSQL database own users?
Previous Message Stanimir Stanev 1999-02-05 10:22:25 Re: [SQL] Has every postgreSQL database own users?