Delphix Products

Expand all | Collapse all

Disable Constraint when masking a primary key field?

Jump to Best Answer

Renee Greenley02-23-2018 02:39:00 PM

Viswas Patnala02-23-2018 03:08:00 PM

Mouhssine SAIDI02-23-2018 03:16:00 PM

  • 1.  Disable Constraint when masking a primary key field?

    Posted 02-23-2018 02:29:00 PM
    If the field I am masking is a primary key (or foreign key), then should I be checking the 'Disable Constraint' in the job setup? If yes, then is that constraint only disabled for the masking process? I don't see any way to 'Enable Constraint' again, unless that happens automatically or doesn't need to be done.

    Thanks,
    Renee Greenley
    #Masking


  • 2.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 02:37:00 PM
    Hi Renee, Yes that’s right and they are enabled back automatically after the job run. Regards, Mouhssine


  • 3.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 02:39:00 PM
    Great. Thank you Mouhssine.

    Renee


  • 4.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 02:44:00 PM
    Disable & Enable Constraints in Masking GUI didn't work for me on earlier versions of 5.0.2.3 or 5.1.6.0. I was told that these would be functional in next versions. Can you please confirm which DE version are you using if this functionality works for you?


  • 5.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 02:50:00 PM
    Viswas,

    We are currently on an old 5.0.0 version with plans to migrate to the latest version hopefully next week. I am going to wait until after that migration to test this. I will let you know what I find.

    Renee


  • 6.  RE: Disable Constraint when masking a primary key field?
    Best Answer

    Posted 02-23-2018 02:52:00 PM
    Hi all,

    Form more informations cf. https://docs.delphix.com/docs/delphix-masking/delphix-masking-engine-user-guide/understand-and-manag...
    Section "Enabling and Disabling Database Constraints"

    Regards,

    Mouhssine


  • 7.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:01:00 PM
    Thanks Renee! Today, we are manually disabling constraints(DB= ORACLE) before we kick-start our masking job and enabling them after successful execution in current version. Let's see if this has been taken care in GUI in the latest DE version. The delphix_db creation script we used doesn't contain sql's to disable/enable constraints. db creation script should be modified accordingly by delphix support if that is still a concern to fix constraint permission.


  • 8.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:04:00 PM
    Hi,

    What is your database type, maybe it doesn't support this feature cf. https://docs.delphix.com/display/DOCS50/Scheduler+Tab#SchedulerTab-enablinganddisablingdatabaseconst...

    Regards,

    Mouhssine


  • 9.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:08:00 PM
    Oracle 11g


  • 10.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:10:00 PM
    Hi,

    I forgot to ask for the engine one.

    Regards,

    Mouhssine


  • 11.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:14:00 PM
    We observed no action taken against constraints even after disabling them in GUI in DE - 5.0.2.3. This was due to the missing grant constraint permission to delphix_db user in the db user creation script.


  • 12.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:16:00 PM
    OK it does make sens now


  • 13.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:19:00 PM
    Did we take this into consideration and added additional grants to db user creation script? I believe this would be the correct fix to make the functionality work as expected from GUI irrespective of DE version.


  • 14.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:29:00 PM
    Hi,

    In normal way you assigne a user that have all required roles to operate you masking operation, delphix_db have only select on system privs so it shouldn't be use as db user to act on app schemas to mask.

    Regards,

    Mouhssine


  • 15.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 03:33:00 PM
    I agree. In such case, we should update the documentation or have a note somewhere with this role/permission as a pre-requisite to operate on constraints.


  • 16.  RE: Disable Constraint when masking a primary key field?

    Posted 02-23-2018 05:14:00 PM
    If DB is Oracle and masking job is "in place", I suggest you to use "ROWID" as Logical Key. In fact if you leave Logical Key blank, dropping unique index on primary key makes the where clause a full table scan for every update.
    Regards.
    Gianpiero


  • 17.  RE: Disable Constraint when masking a primary key field?

    Posted 05-14-2018 01:36:00 PM
    Is ROWID option works for 5.1.4.0 version? Please let me know if it requires upgrade to any other version of delphix?