From: | leaf_yxj <leaf_yxj(at)163(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to check the role has been granted to which role. Help me to double check . Thanks. |
Date: | 2012-03-31 14:51:59 |
Message-ID: | 1333205519301-5608906.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I want to check the role has been granted to which role. In my working
environment, the all the normal is assigned to role group. when i issue dp,
it only give me the role group privilege. So I need to check which user is
in which user group. THe following is my sql to do that. Is there anybody
has a better way to do it. Thanks. Grace
select DISTINCT user, group_name, grantor, admin_option
from
(select usename AS user,roleid,admin_option from pg_user join
pg_auth_members on ( pg_user.usesysid=pg_auth_members.member)) a,
(select usename AS group_name,roleid from pg_user join pg_auth_members on
(pg_user.usesysid=pg_auth_members.roleid)) b,
(select usename AS grantor,roleid from pg_user join pg_auth_members on
(pg_user.usesysid=pg_auth_members.grantor)) c
where a.roleid=b.roleid
and b.roleid=c.roleid;
member | group_name | grantor | admin_option
--------+------------+---------+--------------
user1 | grace | gpadmin | f
user_1 | grace | gpadmin | f
(2 rows)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-check-the-role-has-been-granted-to-which-role-Help-me-to-double-check-Thanks-tp5608906p5608906.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-03-31 16:35:53 | Re: pg_dump incredibly slow dumping a single schema from a large db |
Previous Message | Janning Vygen | 2012-03-31 11:21:20 | Re: PANIC: corrupted item pointer |