Data Masking - auto generate scripts

From: Jeff C <>
Date: Tue, 30 Dec 2014 15:35:50 -0800
Message-ID: <>

Is there a way to schedule generating a masking script? Or better yet, scheduling a script generation and executing the script. In EM 11 and 12 it seems that you have to pre-create the script. This has caused some problems because the script finds all the table permissions and revokes and re-grants permissions. But if I remove a permission but forgot to regenerate a script the whole masking script fails with something like: can't revoke permission not granted.
I want to automate the whole thing. I currently have a script on a schedule to use rman duplicate to create a clone of my database. Then I want to schedule the masking to happen right after that is done. I don't have a license for the Provisioning pack, but if that is the only way this is possible then I will have to try to get that approved but that wont be easy.

EE w/ Masking Pack
Windows Server 2008R2
Enterprise Manager 11g is currently where my Masking definitions are but I am working on converting them to my setup of EM.


Received on Wed Dec 31 2014 - 00:35:50 CET

Original text of this message