OraFAQ Forum: SQL & PL/SQL » Data masking in oracle

Home » SQL & PL/SQL » SQL & PL/SQL » Data masking in oracle (Oracle )

Fri, 11 June 2021 12:14

bkbora
Messages: 21
Registered: April 2020

Junior Member

Hi,
Can someone guide me script or steps to data masking .
I need to mask the production data when it will use in uat env.
Appreciate your help.

Fri, 11 June 2021 12:47

John Watson
Messages: 9005
Registered: January 2010
Location: Global Village

Senior Member

Are you talking about this -

https://www.oracle.com/uk/database/technologies/security/data-masking-subsetting.html

if so, the first step is that you have to buy it. The rest is easy Smile

Fri, 11 June 2021 12:47

Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which Oracle version?

And if you want to continue to get help you should envisage to feedback in your topics.

Fri, 11 June 2021 14:51

Solomon Yakobson
Messages: 3317
Registered: January 2010
Location: Connecticut, USA

Senior Member

DBMS_REDACTION, DBMS_RLS.

SY.

Fri, 11 June 2021 21:59

bkbora
Messages: 21
Registered: April 2020

Junior Member

Oracle 19c and 12c

Previous Topic:	CHR(n) equivalent function for double-byte characters
Next Topic:	dbms_scheduler.create_job() throws error ORA-27362

Goto Forum:

]

Current Time: Sun Sep 20 00:45:36 CDT 2026