Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Data Access pairing with Job Roles — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Access pairing with Job Roles

Received Response
45
Views
8
Comments
edited Sep 17, 2020 9:36PM in Applications Security 8 comments

Summary

Is the Data Access requirement for a particular Job role set by Oracle and is it statis?

Content

Good evening,

I would like to catalog all of the Job Role/Data Access points required by Oracle Cloud via SQL.  For instance, Accounts Payable Manager uses a Data Access of Business Unit while other roles may use Business unit and Reference Data Set while still others use Asset Book or Ledger.

I believe the the table to use is fun_role_data_security_mapping.

My Questions are:  Is this updatable by anyone other than Oracle, meaning it's a static table?  Should the data pulled from this table be used to catalog all possible Job Role/Data Access points?   My current query looks like this:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!