Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center