Query Logs

the query logs tab, accessible from database activity monitoring > database session log > query logs it presents all sql statements executed by users within each session this feature is critical for auditing and understanding user behavior in the database fields description host ip address of the target database device db server name name or label of the connected server protocol database protocol (e g , oracle, mssql, postgresql) db port original database port proxy port the sql proxy port is set for this session db user the user credentials are used at the database level global user the kron dam user is associated with the session client ip ip address of the connecting client log the full sql query text (e g , select, update, delete) records affected number of rows impacted by the query process time duration of the query sql error any error message returned by the database engine this field is supported by oracle, mssql, postgresql, and mysql details displays masking behavior, approval requirements, or execution status queries tagged with a black key will be labeled as not executed masked queries or blocked queries will also appear here query time timestamp of the sql command execution proxy user enforcement this field is supported only for oracle sql error this field is supported by oracle, mssql, postgresql, and mysql rows affected this field is supported by oracle, mssql, and postgresql sql proxy metadata sync period this parameter determines the interval (in milliseconds) at which metadata is fetched or synchronized from the database the default is 30000 (30 seconds) adjust itbased on the frequency of metadata changes and performance needs application properties need to be edited in /pam/sql/config/application properties on a linux device with pam then restart the `pam sql` service