Redshift Observatory

System Table Tracker

System view information_schema.role_usage_grants version 1.0.52931 / 2023-07-07

schema	name	column	data type
information_schema	role_usage_grants	grantee	sql_identifier
information_schema	role_usage_grants	grantor	sql_identifier
information_schema	role_usage_grants	is_grantable	character_data
information_schema	role_usage_grants	object_catalog	sql_identifier
information_schema	role_usage_grants	object_name	sql_identifier
information_schema	role_usage_grants	object_schema	sql_identifier
information_schema	role_usage_grants	object_type	character_data
information_schema	role_usage_grants	privilege_type	character_data

View Text

SELECT CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS grantor,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS grantee,
       CAST(current_database() AS information_schema.sql_identifier) AS object_catalog,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS object_schema,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS object_name,
       CAST(CAST(NULL AS information_schema.character_data) AS information_schema.character_data) AS object_type,
       CAST(CAST('USAGE' AS information_schema.character_data) AS information_schema.character_data) AS privilege_type,
       CAST(CAST(NULL AS information_schema.character_data) AS information_schema.character_data) AS is_grantable
WHERE FALSE

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