Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Create data security policy to exclude specific BUs for custom AP role

edited Jul 30, 2021 8:46PM in Applications Security 5 comments

Content

We have a requirement to create a custom data security policy for AP custom role to exclude specific BUs. Instead of using the instance set - "Access the business unit for FUN_ALL_BUSINESS_UNITS_V for the business units for which they are authorized" we wanted to create our own instance set that exclude one or more BUs so that it can be assigned to our custom role.

Please let me know how to create a custom security policy using the below sql predicate
&TABLE_ALIAS.BU_ID IN (SELECT BU_ID, BU_NAME, SHORT_CODE FROM FUN_ALL_BUSINESS_UNITS_V WHERE STATUS ='A' AND BU_NAME NOT LIKE 'Payroll BU')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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