Information access with the TRACEDATA resource

The TRACEDATA resource controls access to information in the trace log.

About this task

The two types of information that are contained within the Data Virtualization Manager server trace log:

SQL source statements (the real SQL source statements, as taken from database request modules or prepared strings, which may contain objects such as table names or column names).
Binary data that underlies the trace log.

Users who have READ authority for the TRACEDATA resource and READ authority for AVZ and TRACEBROWSE can view the entire trace log. Users who do not have READ authority have only restricted access to this information.

For SQL events, if your user ID matches the user ID associated with the event, you are permitted to look at an uncensored log of the SQL event. Otherwise, you can only see a censored representation of the SQL statement. The censored version includes the SQL verb but does not include objects, such as table names or column names.

The TRACEDATA resource restricts data differently, depending on the type of event:

SQL Events: If your user ID matches the user ID associated with the event, you are permitted to look at an uncensored log of the SQL event. Otherwise, you can only see a censored representation of the SQL statement. The censored version includes the SQL verb but does not include objects, such as table names or column names.
Non-SQL Events: If your user ID matches the user ID associated with the event, you are permitted to see an uncensored view of the underlying binary data for event. Otherwise, you are not allowed to see the binary data at all; no data is displayed and a message is written to the terminal.