View/Table details for Data Security

Question

Summary:

Hi Everyone,

We have built some custom pages and are looking to apply Fusion security on those pages. In order to do so, we require the Secure View/ Table details for Data Security, Data Role, Person Security Profiles and Area of Responsibility. Any help is highly appreciated.

Regards,

MSK

Amrita Gupta-Oracle · Answer

Hi,

For Data Access set information related to GL, you can use the below tables -

GL_ACCESS_SET_LEDGERS

GL_ACCESS_SETS

GL_ACCESS_SET_ASSIGNMENTS

Nishanth B Jain · Answer

you can use FUN_USER_ROLE_DATA_ASGNMNTS table