Redshift Observatory

System Table Tracker

System view information_schema.role_usage_grants version 1.0.68520 / 2024-06-14

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