Thread: Where can I get Users and Roles information in PostgreSQL

Hi all,

I am new bee to PostgreSQL. Where can I get Users and Roles information in
PostgreSQL.

eg : In SQL-SERVER we can get users information using 'sysusers' table.

advance thanks for helping,

regards,
sreedhar

On Mon, 4 Feb 2002, sreedhar wrote:

> Hi all,
>
> I am new bee to PostgreSQL. Where can I get Users and Roles information in
> PostgreSQL.
>
> eg : In SQL-SERVER we can get users information using 'sysusers' table.
>
> advance thanks for helping,

I'm new too, so this may not be the best answer, but it's useful anyway.

If you are a superuser (ie: you can create other users), try this:

select * from pg_shadow;

Warning: Passwords will be shown in plain text. If you don't want anyone
to see, make sure nobody is standing behind you!

Andy

--
acruhl@sdf.lonestar.org
SDF Public Access UNIX System - http://sdf.lonestar.org

Have a look at the system views pg_user and pg_group
- Stuart

> -----Original Message-----
> From: Andy Ruhl [mailto:acruhl@sdf.lonestar.org]
> Sent: 04 February 2002 13:33
> To: sreedhar
> Cc: PostgreSQL
> Subject: Re: Where can I get Users and Roles information in PostgreSQL
>
>
> On Mon, 4 Feb 2002, sreedhar wrote:
>
> > Hi all,
> >
> > I am new bee to PostgreSQL. Where can I get Users and Roles
> information in
> > PostgreSQL.
> >
> > eg : In SQL-SERVER we can get users information using
> 'sysusers' table.
> >
> > advance thanks for helping,
>
> I'm new too, so this may not be the best answer, but it's
> useful anyway.
>
> If you are a superuser (ie: you can create other users), try this:
>
> select * from pg_shadow;
>
> Warning: Passwords will be shown in plain text. If you don't
> want anyone
> to see, make sure nobody is standing behind you!
>
> Andy
>
> --
> acruhl@sdf.lonestar.org
> SDF Public Access UNIX System - http://sdf.lonestar.org
>
>