From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to get the users name from users group? |
Date: | 2010-02-19 10:28:03 |
Message-ID: | 9837222c1002190228k62bcfd93h4c1f9092263e738a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/2/19 Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>:
> Hello All,
>
> I have created role "database-users" and inserted some of users inside it. Could you tell me which query to use for listing out those users name? I went through pg_users, pg_group but no luck.
>
> CREATE ROLE database-users
> NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
>
> CREATE ROLE "dbuser1" LOGIN
> NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
> GRANT database-users TO "dbuser1";
>
> CREATE ROLE "dbuser2" LOGIN
> NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
> GRANT database-users TO "dbuser2";
>
> How to query database-users to list the dbuser1 and dbuser2?
I think you're looking for:
SELECT rolname from pg_authid a INNER JOIN pg_auth_members m ON
m.member=a.oid WHERE m.roleid=(SELECT oid FROM pg_authid WHERE
rolname='database-users')
or something similar to that.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | wilczarz1 | 2010-02-19 10:32:05 | Re: PERFORM not working properly, please help.. |
Previous Message | Pavel Stehule | 2010-02-19 10:04:48 | Re: PERFORM not working properly, please help.. |