Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 8 Auditing Accesses : Creating, Editing, and Deleting Filters

Creating, Editing, and Deleting Filters
If you require a different set of criteria for a query or you want to create a new filter, initiate an editing session from the Audit Log screen. You can also delete a filter that you defined.
Creating a Filter
To create a new filter, complete the following steps:
1.
Type E in the line command field of the filter that you want to use as a prototype.
2.
This displays a screen similar to the one shown below, which you can edit.
3.
Enter selection criteria directly into the Selection Criteria portion of the screen or select the criteria from the display in the bottom portion of the screen.
When specifying selection criteria enclose character data in single quotes, for example: OBJECT=’DEPARTMENTS’.
4.
5.
6.
This saves the changes and returns you to the Audit Log screen.
Audit Log Filter Definition Screen

 
------------------------------------------------------------------------------
Audit Log Filter Definition
------------------------------------------------------------------------------
Name: OBJECT_ACCESS
Description: Accesses on all object types
+----------------------------------------------------------------------------+
| Selection Criteria |
| -------------------------------------------------------------- |
| OBJECT_TYPE = ’LIBRARY’ OR OBJECT_TYPE = ’REPORT’ OR |
| OBJECT_TYPE = ’SCREEN’ OR OBJECT_TYPE = ’TABLE’ |
| |
+----------------------------------------------------------------------------+
Fields of ACCESSLOG
_ TIME _ USER _ USER_CLEARANCE _ OBJECT
_ OBJECT_CLASSFCTN _ ACCESS_ALLOWED _ MESSAGE_NO _ PARM1
_ PARM2 _ ACTIVITY _ OBJECT_TYPE
Relational Operator
_ = _ < _ > _ <= _ >= _ ¬= _ LIKE
Value / Expression
Logical Operator
_ AND _ OR
PFKEYS: 1=HELP 3=SAVE 12=CANCEL 14=TBLS 15=RPTS 16=SCRS 17=LIBS 20=ACTIVITIES

 
Editing a User-Defined Filter
To edit an existing filter that you defined, use the same procedure that you used to create a filter, omitting step 5.
You cannot modify a default filter. To save editing changes that are made to a default filter, rename the filter before you save it.
Deleting a User-Defined Filter
You can delete filters that you defined, but not default filters. To delete one of your own filters, type D in the line command field beside the filter that you want to delete. After pressing Enter, you are prompted to confirm the deletion.
Samples of User Defined Selections
The following are examples of selection statements for user-defined filters:
Activity=’Insert’ OR Activity=’Delete’ OR Activity=’Replace’)AND Object=’DEPARTMENTS’
For this example to work, accesses to the DEPARTMENTS table must be logged. For more information about logging accesses, refer to Task D: Logging Accesses to a Table.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved