Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

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