Redshift Observatory

System Table Tracker

System view information_schema.applicable_roles version 1.0.54052 / 2023-07-28

schema	name	column	data type
information_schema	applicable_roles	grantee	sql_identifier
information_schema	applicable_roles	is_grantable	character_data
information_schema	applicable_roles	role_name	sql_identifier

View Text

SELECT CAST("current_user"() AS information_schema.sql_identifier) AS grantee,
       CAST(g.groname AS information_schema.sql_identifier) AS role_name,
       CAST(CAST('NO' AS information_schema.character_data) AS information_schema.character_data) AS is_grantable
FROM pg_group AS g, pg_user AS u
WHERE u.usesysid = ANY(g.grolist)
  AND u.usename = CAST("current_user"() AS name)

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers