Postgres Pro
Downloads
Home   >   mailing lists

find out all users under specific user - Mailing list pgsql-admin

From ashok@kalculate.com
Subject find out all users under specific user
Date
Msg-id 380-22006541817540109@M2W005.mail2web.com
Whole thread Raw
Responses Re: find out all users under specific user  ("Ben K." <bkim@coe.tamu.edu>)
List pgsql-admin
Tree view 
Hi List,

I want to find out all the users under a specific user.
postgres is a superuser of postgresql,
under in postres user i made one user ABC and
under this ABC user i made XYZ,MNO,IJK users.

Now i want to find out all the users, which r exist
under in ABC user so what is the query for it?

plz. help me.
Thanks

Ashok



--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .

pgsql-admin by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: lock a database from new connections, without modifying pg_hba.conf
Next
From: Tom Lane
Date:
Subject: Re: lock a database from new connections, without modifying pg_hba.conf