pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedfind out all users under specific user
2+ messages / 2 participants
[nested] [flat]
* find out all users under specific user
@ 2006-05-18 17:54 ashok@kalculate.com <ashok@kalculate.com>
2006-05-20 16:02 ` Re: find out all users under specific user Ben K. <bkim@coe.tamu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: ashok@kalculate.com @ 2006-05-18 17:54 UTC (permalink / raw)
To: pgsql-admin
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/ .
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: find out all users under specific user
2006-05-18 17:54 find out all users under specific user ashok@kalculate.com <ashok@kalculate.com>
@ 2006-05-20 16:02 ` Ben K. <bkim@coe.tamu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Ben K. @ 2006-05-20 16:02 UTC (permalink / raw)
To: ashok@kalculate.com <ashok@kalculate.com>; +Cc: pgsql-admin
> 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?
select relname, array_to_string(relacl,',') as acl from pg_class
where array_to_string(relacl,',') ~ '/ABC[,$]';
HTH
Ben K.
Developer
http://benix.tamu.edu
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-05-20 16:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-18 17:54 find out all users under specific user ashok@kalculate.com <ashok@kalculate.com>
2006-05-20 16:02 ` Ben K. <bkim@coe.tamu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox