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:

1. Open BI Administration tool, and click Manage > Identity.
2. Double-click the name of the user to select, and update the logging level in the pop-up menu.
3. Enter the following information in the Logging Level:
   1. Level 0—No Logging
   2. Level 1—Logged details are SQL statements, query response durations, user id, session id, request id.
   3. 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.
   4. Level 3—Everything Logged in level 2 with additional information such as logical query plan, purged cache, etc.
   5. Level 4—Everything Logged in level 3 with additional information of query execution plan.
   6. Level 5—Everything Logged in level 4 with detailed query execution plan