My Oracle Support Banner

How To Restrict Access To User Defined Tables Via Roles (Doc ID 2372574.1)

Last updated on APRIL 18, 2019

Applies to:

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


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.


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

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