How-to debug Custom Data Role using BIP SQL script

Summary

A self-help guide to overcoming custom security setup issues.

Content

This paper provides a step by step exercise demonstrating how to troubleshoot complex data security setup issues.  The SQL output will detail valid data security policies in the context of that userid login session, for instance:

• ROLE_GUID_IN_SYNC

"No" signifies role guids out of sync, request CloudOps to run GUID reconciliation program.  

The recipient of a grant can be either an application role or an enterprise role. In Oracle Fusion Data Security and Policy Grants this recipient is identified by a GUID, and it is crucial for the security system to work as expected that these GUIDs are consistent.