Blitz Report VPD Policy Setup

➜ Back to Library
Description
Categories: Application, Enginatics
Repository: Github Columns: Lookup Code, Owner, Table Name, Column Name, Vpd Policy Active, Description, Tag, Enabled, Start Date Active, End Date Active ...
Lists tables and columns to be secured by Blitz Report's VPD policy functionality (concurrent program 'Blitz Report Update VPD Policies') from lookup XXEN_REPORT_VPD_POLICY_TABLES and validates if corresponding DB policies have been created. 
select
flv.lookup_code,
flv.owner,
flv.table_name,
flv.column_name,
xxen_util.meaning((select 'Y' from dba_policies dp where dp.policy_name='XXEN_VPD' and flv.owner=dp.object_owner and flv.table_name=dp.object_name and dp.enable='YES'),'YES_NO',0) vpd_policy_active,
flv.description,
flv.tag,
xxen_util.meaning(decode(flv.enabled_flag,'Y','Y'),'YES_NO',0) enabled,
flv.start_date_active,
flv.end_date_active,
case
when flv.column_name is not null and atc.column_name is null then 'Column not found'
when flv.table_name is not null and at.table_name is null then 'Table not found'
when flv.table_name is null then 'Please specify table or columns in format: owner.table_name.column_name'
end validation_error,
flv.meaning,
xxen_util.user_name(flv.created_by) created_by,
xxen_util.client_time(flv.creation_date) creation_date,
xxen_util.user_name(flv.last_updated_by) last_updated_by,
xxen_util.client_time(flv.last_update_date) last_update_date
from
(
select
regexp_substr(flv.meaning,'[^\.]+',1,1) owner,
regexp_substr(flv.meaning,