Data Masking - auto generate scripts
From: Jeff C <backseatdba_at_gmail.com>
Date: Tue, 30 Dec 2014 15:35:50 -0800
Message-ID: <CAKsxbLrkhY3S9Mo3_MBbGeiv6ONF03p43pW9jauRePX_=aN=XQ_at_mail.gmail.com>
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.
Date: Tue, 30 Dec 2014 15:35:50 -0800
Message-ID: <CAKsxbLrkhY3S9Mo3_MBbGeiv6ONF03p43pW9jauRePX_=aN=XQ_at_mail.gmail.com>
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 11.2.0.2 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 12.1.0.3 setup of EM.
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 31 2014 - 00:35:50 CET