ADD_PSA_OBJECTΒΆ

Add new GDPR PSA Objects.

Table: REDGPR.GPR_PSA_OBJECTS (This table list all PSA objects, which are processed for GDPR)

Parameter Name

Properties

Default Value

Parameter Description

p_psa_schema

(PK)(NN)

Name of the schema of the PSA table whch is subject to GDPR changes

p_psa_table

(PK)(NN)

Name of the PSA table whch is subject to GDPR changes

p_trg_view

(PK)(NN)

Name of the GPR trigger data view

p_gpr_view

(NN)

Name of the dedicated GDPR view

p_active

(NN)

FALSE

(de)activate GDPR changes for PSA table

Example

EXECUTE SCRIPT api_redgpr.add_psa_object
            ( 'XXXXXXXXXXXX'    -- p_psa_schema
            , 'XXXXXXXXXXXX'    -- p_psa_table
            , 'XXXXXXXXXXXX'    -- p_trg_view
            , 'XXXXXXXXXXXX'    -- p_gpr_view
            , FALSE             -- p_active
            );