Re: Listing users

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(at)gmx(dot)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