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
