Re: Listing users - Mailing list pgsql-general

From wayne
Subject Re: Listing users
Date
Msg-id 3BD69EC5.200CFF1D@verizon.net
Whole thread Raw
In response to Re: Listing users  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
How would you find out who was authorize to use what DB?
WAyne

Peter Eisentraut wrote:

> Keary Suska writes:
>
> > The easiest way is to cat ~postgres/data/global/pg_pwd,
>
> No way.
>
> > but if that doesn't tell you what you need to know, you can SELECT *
> > FROM pg_shadow (works when connected to any database as long as you
> > are the postgres superuser).
>
> That or SELECT * FROM pg_user;
>
> --
> Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Disable Transaction - plans ?
Next
From: Vince Vielhaber
Date:
Subject: Re: poor with mirrors