Masking a column using dbms_redact

Masking a column using dbms_redact

 

To mask a sensitive data from any column using dbms_redact package.

Here profile column in redactt table is masked.

[oracle@tom ~]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 – Production on Sat Jun 19 01:12:28 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0

SQL>
SQL> grant execute on sys.dbms_redact to doyt;

Grant succeeded.

SQL> conn doyt/doyt
Connected.

To drop the policy