The Specify Event Filter Criteria windows allow you to use words, phrases, and wildcards to further define your audit event filter criteria. For example, you can use this window to filter out events that occur on all databases in your environment that use a naming convention such as "dbname01".
Available actions
Filter events on objects whose names match the listed words, phrases, or wildcards
To filter events on objects with specific names or naming conventions, click listed, and then specify the words, phrases, or wildcards the object names should match. You can add more than one criterion.
Filter events on objects whose names are not listed
To filter events on objects whose names are not listed, click except those listed, and then specify the words, phrases, or wildcards the object names should not match. You can add more than one criterion.
Available fields
Match all <event filter criteria>
Allows you to indicate whether the event filter should generate alerts for objects that match the listed names, phrases, or wildcards.
Specify <alert criteria> to match
Allows you to define match criteria. Match criteria can include exact names, words, phrases, or wildcards. For each match criterion you want to define, type the appropriate word, phrase, or wildcard in the provided field, and then click Add.
Use the following examples to help you define wildcard match criteria. Note that wildcard matches are not case-sensitive.
If you want to match … | Use … | Examples | ||
---|---|---|---|---|
One digit | # | You want: All databases with name of testNN | You specify: test## | You get: Test00Test01test#1 |
One character | ? | You want: All databases with name of testXX | You specify: test?? | You get: Test00Test01TEST?htester |
Any character | * | You want: All databases that start with test | You specify: test* | You get: Test00Test01test0101test4metest#1TEST?htest*devtestertest |
<Event filter criteria> to match
Allows to you change the list of match criteria. You can add a new criterion or remove an existing criterion.