Amazon Redshift でユーザーに付与されたスキーマ権限を確認する

Amazon Redshift でユーザーに付与されたスキーマ権限を確認する。

select
        usename
        , schemaname
        , has_schema_privilege(usename, schemaname, 'usage') as "usage"
        , has_schema_privilege(usename, schemaname, 'create') as "create"
        , has_schema_privilege(usename, schemaname, 'alter') as "alter"
        , has_schema_privilege(usename, schemaname, 'drop') as "drop"
from
  pg_tables, pg_user
where schemaname in(
'test_schema'
)
order by
1, 2
;
usename|schemaname|usage|create|alter|drop
IAM:akihitan_test|test_schema|f|f|f|f
IAMR:Admin|test_schema|f|f|f|f
awsuser|test_schema|t|t|t|t
bi_user|test_schema|t|f|f|f
obj_admin|test_schema|t|t|t|t
rdsdb|test_schema|t|t|t|t
schema_owner|test_schema|t|t|t|t
testuser|test_schema|f|f|f|f