View/Table details for Data Security

Maruvada Sanat Kumar-Oracle

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

Nishanth B Jain

you can use FUN_USER_ROLE_DATA_ASGNMNTS table

Amrita Gupta-Oracle

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