APM : How To Find all roles & data security predicate associated with a user session (Doc ID 1575709.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Common CRM - Version 11.1.4.0.0 and later
Oracle Fusion Common CRM Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

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.

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms