CHANGE_SCOL_DISCOVER_RULE

Modify a discover rule for sensitive columns.

Parameter Name	Required	DefaultValue	Description
p_rule_id	yes		discover rule ID
p_schema_incl_pattern	yes	.*	schema include pattern (null to keep unchanged, ‘ ‘ to set to default)
p_schema_excl_pattern	no		schema exclude pattern (null to keep unchanged, ‘ ‘ to clear value)
p_object_incl_pattern	yes	.*	object include pattern (null to keep unchanged, ‘ ‘ to set to default)
p_object_excl_pattern	no		object exclude pattern (null to keep unchanged, ‘ ‘ to clear value)
p_column_incl_pattern	yes	.*	column include pattern (null to keep unchanged, ‘ ‘ to set to default)
p_column_excl_pattern	no		column exclude pattern (null to keep unchanged, ‘ ‘ to clear value)
p_comment_incl_pattern	yes	.*	comment include pattern (null to keep unchanged, ‘ ‘ to set to default)
p_comment_excl_pattern	no		comment exclude pattern (null to keep unchanged, ‘ ‘ to clear value)
p_rule_comment	no		rule comment (null to keep unchanged, ‘ ‘ to clear value)

Example

EXECUTE SCRIPT api_scurty.change_scol_discover_rule
           ( 5                -- p_rule_id
           , 'SCOTT.*'        -- p_schema_incl_pattern
           , ' '              -- p_schema_excl_pattern
           , NULL             -- p_object_incl_pattern
           , NULL             -- p_object_excl_pattern
           , '.*'             -- p_column_incl_pattern
           , 'D.*'            -- p_column_excl_pattern
           , '.*'             -- p_comment_incl_pattern
           , '.*@@NOT SEC RELEVANT@@.*'   -- p_comment_excl_pattern
           , 'Test rule for discovering sensitive columns.' -- p_rule_comment
           );