Redshift Observatory

System Table Tracker

System view pg_catalog.svv_user_grants version 1.0.106073 / 2025-01-23

schema	name	column	data type
pg_catalog	svv_user_grants	admin_option	bool
pg_catalog	svv_user_grants	role_id	int4
pg_catalog	svv_user_grants	role_name	varchar(128)
pg_catalog	svv_user_grants	user_id	int4
pg_catalog	svv_user_grants	user_name	varchar(128)

View Text

SELECT user_roles.user_id,
       CAST(user_roles.user_name AS varchar(128)) AS user_name,
       user_roles.role_id,
       CAST(user_roles.role_name AS varchar(128)) AS role_name,
       user_roles.admin_option
FROM pg_get_user_grants() AS user_roles(user_id integer,
                                        user_name varchar,
                                        role_id integer,
                                        role_name varchar,
                                        admin_option boolean)

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 System Table Tracker The Known Universe White Papers