ADD_TENANT

Add a tenant.

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

Example

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