My Oracle Support Banner

How To Find All Roles & Data Security Predicates Associated with a User Session (Doc ID 1575709.1)

Last updated on FEBRUARY 04, 2019

Applies to:

Oracle Fusion Common CRM - Version to [Release 1.0]
Oracle Fusion Common CRM Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


How To Find all roles & data security predicate associated with a user session

This is useful to check efficiency and coherency of APM (Authorization Policy Manager) setup

First login to the Fusion application, navigate to the page the user commonly access.  
The reason for it is that each page in the application is managed by an application domain where it
belongs to a stripe of the Fusion application.  
Each time it launch an application domain, it start a new session means the session cookie
in your browser change along the way.  So navigate throughout the application on all the common pages
that used by the common business processes before capturing the session_ccokie that you going to use
for your analysis.  
Once you have the session_cookie string, use the 2 sql statements that provided for your analysis.  
For the list of all roles that user session have access to, use the first sql statement.  
The second sql statement will give you all predicates (data security) associate to that user’s session.  
This is extremely important information for troubleshooting access.  
It provide all data that user’s have access to.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 How To Find all roles & data security predicate associated with a user session

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.