advance security
BEGIN
DBMS_REDACT.add_policy (object_schema => 'ES_REPORTS',
object_name => 'BOM_FORM32_POSTING',
column_name => 'UIN',
policy_name => '"Reduct_UIN"',
function_type => DBMS_REDACT.full,
expression => '1=1');
END;
/
i apply this , executed successful but when i query the column they never hide the column data while i try this on test machine it working fine .what i missing here in production .
both prod and test machine on 19c