Redshift Research Project

System Table Tracker

System view pg_catalog.svv_user_grants version 1.0.51973 / 2023-06-17

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 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