The following table lists the rules DBQL validates when DBQL logging begins. DBQL checks against the application name, user name, and account string to validate rules.
| Event | Action |
|---|---|
| User logs on to start a session | DBQL checks the username, account string, and application name in the rules cache and also looks for this in the dictionary table. |
| Match is found in the rules cache | DBQL logs according to any options in the rules table. |
| Match is not found in the rules cache | DBQL searches for a matching user or account in the Data Dictionary. |
| mMatchatch is found in the Data Dictionary | DBQL creates an entry in the rules cache and logs according to any options in the rules table. |
| Match is not found in the Data Dictionary | DBQL creates a "do not log" rule in the rules cache, but does not perform logging. |
| "WITH NONE" rule is found | DBQL creates a "do not log" rule in the rules cache, but does not perform logging. Because DBQL is controlled at the system level on VantageCloud Lake, the "WITH NONE" rule is void.
|
If the account string of a session is changed using the SET SESSION ACCOUNT statement, the system makes sure that any rules associated with the user and account string applies when the next query is issued from that session.