ablog

不器用で落着きのない技術者のメモ

Redsfhit でどのグループにユーザーが所属しているか確認する

AWS
  • クエリ
select pg_user.usename, pg_user.usesysid, pg_group.groname, pg_group.grolist from pg_user,pg_group;
  • 実行結果
           usename            | usesysid |          groname           | grolist 
------------------------------+----------+----------------------------+---------
 rdsdb                        |        1 | dwh_batch_group            | {136}
 awsuser                      |      100 | dwh_batch_group            | {136}
 dwh_batch_user_01            |      136 | dwh_batch_group            | {136}
 short_dwh_tools_user_01      |      137 | dwh_batch_group            | {136}
 short_users_l1_user_01       |      138 | dwh_batch_group            | {136}
 short_users_l2_user_01       |      139 | dwh_batch_group            | {136}
 short_application_l2_user_01 |      140 | dwh_batch_group            | {136}
 rdsdb                        |        1 | short_dwh_tools_group      | {137}
 awsuser                      |      100 | short_dwh_tools_group      | {137}
 dwh_batch_user_01            |      136 | short_dwh_tools_group      | {137}
 short_dwh_tools_user_01      |      137 | short_dwh_tools_group      | {137}
 short_users_l1_user_01       |      138 | short_dwh_tools_group      | {137}
 short_users_l2_user_01       |      139 | short_dwh_tools_group      | {137}
 short_application_l2_user_01 |      140 | short_dwh_tools_group      | {137}
 rdsdb                        |        1 | short_users_l1_group       | {138}
 awsuser                      |      100 | short_users_l1_group       | {138}
 dwh_batch_user_01            |      136 | short_users_l1_group       | {138}
 short_dwh_tools_user_01      |      137 | short_users_l1_group       | {138}
 short_users_l1_user_01       |      138 | short_users_l1_group       | {138}
 short_users_l2_user_01       |      139 | short_users_l1_group       | {138}
 short_application_l2_user_01 |      140 | short_users_l1_group       | {138}
 rdsdb                        |        1 | short_users_l2_group       | {139}
 awsuser                      |      100 | short_users_l2_group       | {139}
 dwh_batch_user_01            |      136 | short_users_l2_group       | {139}
 short_dwh_tools_user_01      |      137 | short_users_l2_group       | {139}
 short_users_l1_user_01       |      138 | short_users_l2_group       | {139}
 short_users_l2_user_01       |      139 | short_users_l2_group       | {139}
 short_application_l2_user_01 |      140 | short_users_l2_group       | {139}
 rdsdb                        |        1 | short_application_l2_group | {140}
 awsuser                      |      100 | short_application_l2_group | {140}
 dwh_batch_user_01            |      136 | short_application_l2_group | {140}
 short_dwh_tools_user_01      |      137 | short_application_l2_group | {140}
 short_users_l1_user_01       |      138 | short_application_l2_group | {140}
 short_users_l2_user_01       |      139 | short_application_l2_group | {140}
 short_application_l2_user_01 |      140 | short_application_l2_group | {140}
(35 rows)

参考