Redshift Observatory

System Table Tracker

System view information_schema.enabled_roles version 1.0.76832 / 2024-10-24

schema	name	column	data type
information_schema	enabled_roles	role_name	sql_identifier

View Text

SELECT CAST(g.groname AS information_schema.sql_identifier) AS role_name
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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers