ADD_REFRESH_EXCLUDE_RULE

Implements an exclusion rule for SCURTY refreshes. A SCURTY refresh is a job that synchronizes the SCURTY repository with the Oracle Database dictionary. Refreshes may be excluded for specific DDL event types, object types or database objects. Only refreshes triggered immediately after a change are excluded, periodic refreshes still apply.

To exclude specific database session-users, OS-users, services, programs, machines, actions and/or modules from SCURTY refreshes, use procedure add_no_ddl_refresh_rule.

For information about the purpose of excluding objects from SCURTY refreshes, see the description “Purpose of procedures add_no_ddl_refresh_rule and add_refresh_exclude_rule”.

Usage

Rules can identify DDL event types, object types or database objects. For example, a rule may exclude refreshes for the creation (event type) of tables (object type) whose names start with “ADM…”.

This procedure inserts a row into table REP_REFRESH_EXCLUDE.

Parameter Name

Required

DefaultValue

Values

Description

p_ddl_event_pattern

no

.*

A regular expression that matches one or more DDL events.

Possible event types to match are:

  • ALTER

  • CREATE

  • DROP

  • RENAME

  • COMMENT

Default value: ‘.*’ (= all events)

A NULL value is not allowed.

p_object_type_pattern

no

.*

A regular expression that matches one or more object types.

Possible object types to match are:

  • TABLE

  • VIEW

  • SNAPSHOT

  • COLUMN

Default value: ‘.*’ (= all object types)

A NULL value is not allowed.

p_object_owner_pattern

no

.*

A regular expression that matches one or more object owner names.

Default value: ‘.*’ (= all object owner names)

A NULL value is not allowed.

p_object_name_pattern

no

.*

A regular expression that matches one or more object names.

Default value: ‘.*’ (= all objects)

A NULL value is not allowed.

p_rule_comment

no

A comment regarding the rule.

Example

The following statement adds a rule to not trigger SCURTY refreshes for the DDL events ‘CREATE’ and ‘ALTER’ of tables whose owner schema name start with ‘ADM’. The object name is not restricted, it may have any value (‘.*’). The comment ‘ No immediate refresh for tables whose owner names start with ADM’ is added to the rule.

EXEC p_rep_admin.add_refresh_exclude_rule
    ( 'ALTER|CREATE'
    , 'TABLE'
    , 'ADM.*'
    , '.*'
    , 'No immediate refresh for tables whose owner names start with ADM' );