We have a need where we will receive user roles as a view parameter value, then that parameter will be parsed within a custom policy to make sure the role exist, then that role needs to be translated to actual values (which exists in a view within a common database) and then use those values and accept/reject/mask.
For example, a view will receive a parameter including USER_HAS_MBR_ACCESS, USER_HAS_CLIENT!, USER_HAS_CLIENT2. Also, this vies is assigned with a CUSTOM_POLICY which cares about roles USER_HAS_CLIENT! and USER_HAS_CLIENT2. So, in the execute method of the CUSTOM_POLICY, the paramenter will be parsed to make sure these ROLES exists. Then these parameters needs to be translated i.e. USER_HAS_CLIENT1 to 1234, USER_HAS_CLIENT2 to 5678 so on and so forth. This information will reside in another common database view. Is it a possibility to access that view within the CustomPolicy class? Please advise.
