ADD_EXCL_OBJ_DISCOVER_RULEΒΆ

Add a discover rule in order to exclude certain objects from any object group.

Parameter Name

Required

DefaultValue

Description

p_schema_excl_pattern

yes

.*

schema exclude pattern

p_object_excl_pattern

yes

.*

object exclude pattern

p_comment_excl_pattern

yes

.*

comment exclude pattern

p_rule_comment

no

rule comment

Example

In this example we create an exclude rule, to exclude internal objects.

EXECUTE SCRIPT api_scurty.add_excl_obj_discover_rule
           ( 'REDPSA_.*'          -- p_schema_excl_pattern
           , '.*_(DV|PV|PV2|HV|CV|CVR|LV\d{1,}|HT|CTL|ERR|MT|LT\d{1,})' -- p_object_excl_pattern
           , '.*'                 -- p_comment_excl_pattern
           ,'internal objects'    -- p_rule_comment
           );