ba6.us - Dave's Database Related Stuff

Debugging Info

AskTom Thread on debugging VPD

Helpful Role

This roll will help developers that need to investigate VPD issues without having to give them 'Keys to the Castle' DBA Role:

CREATE ROLE VPD_SUPPORT_ROLE;

GRANT SELECT_CATALOG_ROLE TO VPD_SUPPORT_ROLE;

GRANT SELECT ON DBA_AUDIT_POLICIES TO VPD_SUPPORT_ROLE;
GRANT SELECT ON DBA_AUDIT_POLICY_COLUMNS TO VPD_SUPPORT_ROLE;
GRANT SELECT ON DBA_POLICIES TO VPD_SUPPORT_ROLE;
GRANT SELECT ON DBA_POLICY_CONTEXTS TO VPD_SUPPORT_ROLE;
GRANT SELECT ON DBA_POLICY_GROUPS TO VPD_SUPPORT_ROLE;
GRANT SELECT ON GV_$POLICY_HISTORY TO VPD_SUPPORT_ROLE;
GRANT SELECT ON GV_$VPD_POLICY TO VPD_SUPPORT_ROLE;
GRANT SELECT ON KU$_FGA_POLICY_VIEW TO VPD_SUPPORT_ROLE;
GRANT SELECT ON KU$_RLS_POLICY_VIEW TO VPD_SUPPORT_ROLE;
GRANT SELECT ON V_$POLICY_HISTORY TO VPD_SUPPORT_ROLE;
GRANT SELECT ON V_$VPD_POLICY TO VPD_SUPPORT_ROLE;