Where can I get Users and Roles information in PostgreSQL

Поиск
Список
Период
Сортировка
Искать

Where can I get Users and Roles information in PostgreSQL

От:
"sreedhar" <sreedhar@lucidindia.net>
Дата:
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

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

От:
"Henshall, Stuart - WCP" <SHenshall@westcountrypublications.co.uk>
Дата:
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
> 
>

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

От:
Andy Ruhl <acruhl@sdf.lonestar.org>
Дата:
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
FAQ