CHANGE_TENANT

Change a tenant.

Parameter Name	Required	DefaultValue	Parameter-Description
p_tnt_group	yes		tenant group
p_tnt_name	yes		tenant name
p_tnt_match_prio	no		tenant match priority
p_tnt_desc	no		tenant description
p_tnt_data_type	no		tenant data type
p_tnt_col_incl_pattern	no		tenant column include pattern
p_tnt_col_excl_pattern	no		tenant column exclude pattern
p_tnt_schema_incl_pattern	no	‘.*’	tenant schema include pattern
p_tnt_schema_excl_pattern	no		tenant schema exclude pattern
p_tnt_object_incl_pattern	no	‘.*’	tenant object include pattern
p_tnt_object_excl_pattern	no		tenant object exclude pattern
p_tnt_comment_incl_pattern	no	‘.*’	tenant comment include pattern
p_tnt_comment_excl_pattern	no		tenant comment exclude pattern

Example

keep in mind:

NULL => no change in DB ‘ ‘ (Single Space Char ) => set to null or default-value

EXECUTE SCRIPT api_scurty.change_tenant
            ( 'XXX'    -- p_tnt_group
            , 'XXX'    -- p_tnt_name
            , NULL     -- p_tnt_match_prio
            , 'XXX'    -- p_tnt_desc
            , 'XXX'    -- p_tnt_data_type
            , NULL     -- p_tnt_col_incl_pattern
            , 'XXX'    -- p_tnt_col_excl_pattern
            , ' '      -- p_tnt_schema_incl_pattern
            , 'XXX'    -- p_tnt_schema_excl_pattern
            , ' '      -- p_tnt_object_incl_pattern
            , 'XXX'    -- p_tnt_object_excl_pattern
            , ' '      -- p_tnt_comment_incl_pattern
            , 'XXX'    -- p_tnt_comment_excl_pattern
            );