Re: Data Masking - auto generate scripts

From: Niall Litchfield <>
Date: Wed, 31 Dec 2014 09:10:16 +0000
Message-ID: <>

In EM (not sure about but its trivial to check) there's a generate_masking_script verb for emcli. That would seem to fit the bill.

On Tue, Dec 30, 2014 at 11:35 PM, Jeff C <> wrote:

> 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.
> Thanks,
> Jeff

Niall Litchfield
Oracle DBA

Received on Wed Dec 31 2014 - 10:10:16 CET

Original text of this message