Hi Team,
We are having Production database with confidential data like phone number,address,name,bank account number. We want to clone the prod DB into test databases so that developers can work on that.
But we want to mask the above columns in a way it can not be read. Is there any way I can mask few columns on few tables using some stored procedures so that I can schedule the refresh and masking procedure on weekly basis.
I found few articles online which uses OEM but I need using procedures.
Thanks,
Saicharan