Redshift Observatory

System Table Tracker

System view pg_catalog.svv_masking_policy version 1.0.47357 / 2023-03-08

View Text

SELECT CAST(d.datname AS varchar) AS policy_database,
       CAST(p.polname AS varchar) AS policy_name,
       mask_policy_atts_out(CAST(p.polattrs AS varchar)) AS input_columns,
       mask_policy_expr_out(CAST(p.polexpr AS varchar)) AS policy_expression,
       CAST(u.usename AS varchar) AS policy_modified_by,
       p.polmodifiedtime AS policy_modified_time
FROM pg_policy_mask AS p
     INNER JOIN pg_database AS d ON d.oid = p.poldbid
     LEFT JOIN pg_user AS u ON u.usesysid = p.polmodifiedby
WHERE EXISTS (SELECT 1
              FROM pg_identity
              WHERE pg_identity.useid = current_user_id()
                AND pg_identity.usesuper = TRUE)
   OR user_is_member_of(CAST("current_user"() AS name),
                        CAST('sys:secadmin' AS name))

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