Redshift Observatory

System Table Tracker

System view information_schema.usage_privileges version 1.0.76642 / 2024-10-18

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

View Text

SELECT CAST(u.usename AS information_schema.sql_identifier) AS grantor,
       CAST(CAST('PUBLIC' AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS grantee,
       CAST(current_database() AS information_schema.sql_identifier) AS object_catalog,
       CAST(n.nspname AS information_schema.sql_identifier) AS object_schema,
       CAST(t.typname AS information_schema.sql_identifier) AS object_name,
       CAST(CAST('DOMAIN' 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('NO' AS information_schema.character_data) AS information_schema.character_data) AS is_grantable
FROM pg_user AS u, pg_namespace AS n, pg_type AS t
WHERE u.usesysid = t.typowner
  AND t.typnamespace = n.oid
  AND t.typtype = CAST('d' AS "char")


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