How To Restrict Access To User Defined Tables Via Roles

(Doc ID 2372574.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Customer has a requirement to restrict user defined tables (UDTs) for different roles.
Example: UDTs holding master data for location will be only accessible/editable by users having location admin role they will not be able to access/search remaining user defined tables.
Similarly a resignation administrator will only be accessing or updating a user defined table used to manage termination details, this user should not be able to search/access other user defined tables.
 

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