Oracle Data Redaction 12c

Hi Folks,

I have a little issue here with Oracle data redaction. We have implemented data redaction on one of the columns masking zip_code:

BEGINDBMS_REDACT.ADD_POLICY (   object_schema          => 'APEX_ZION',   object_name            => 'DEMO_CUSTOMERS',   policy_name            => 'REDACT_CUST_POSTAL_CODE',   column_name            => 'CUST_POSTAL_CODE',   function_type          => DBMS_REDACT.RANDOM,   expression             => 'SYS_CONTEXT ( ''USERENV'',''SESSION_USER'' ) !=''APEX_ZION''',   enable                 => TRUE   );END;/

Our application is basic apex application, which is displaying content of DEMO_CUSTOMERS table. We use database authentication and not APEX authentication method.

Data redaction works as expected when connected using SQL Developer.

What we expect is, when we login to a database as "apex_zion" we should see real data and when we login using other user account the data should be redacted.