Create data security policy to exclude specific BUs for custom AP role
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')
Tagged:
0