Log Security Restrictions
Query logging level defines the exposure of database queries to Oracle Business Intelligence Enterprise Edition users. By default, each user account's Logging Level is set to 0 (zero), which is no logging. Implement the following steps to set the levels for a user:
- Open BI Administration tool, and click Manage > Identity.
- Double-click the name of the user to select, and update the logging level in the pop-up menu.
- Enter the following information in the Logging Level:
- Level 0—No Logging
- Level 1—Logged details are SQL statements, query response durations, user id, session id, request id.
- Level 2—Everything Logged in level 1 with additional information such as repository name, business model name, subject area name, no of rows returned, etc.
- Level 3—Everything Logged in level 2 with additional information such as logical query plan, purged cache, etc.
- Level 4—Everything Logged in level 3 with additional information of query execution plan.
- Level 5—Everything Logged in level 4 with detailed query execution plan
Parent topic: Minimum Security Configuration Guide