Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS SQL DEVELOPER WEB Audit Logs

User_17YKFMay 27 2020 — edited May 28 2020

Hi Team

Please suggest how can we enable audit logs for ORDS SQL DEVELOPER WEB.

The purpose of these logs is to reveal which user executed which query.

I know that audit logging can be enabled at Oracle DB level but for us enable audit logs will require restarts  which is not feasible. Is there some setting which would write all the entries available in the SQL DEVELOPER  portal --> USER PROFILE -->  LOG  (Refer attached screenshot) to a log file.

ORDS Version -

9.4.0.r3521226

Application Server - Oracle Weblogic 14.1

Comments

thatJeffSmith-Oracle

if you want to know what database users are doing, you'll need to use the auditing built into the database

the only other recourse you have is to mine your web server access logs

User_17YKF

Access logs do not provide much insight into user activity except from the uri visited and the status code.
If ORDS is presenting the logs(Containing user activity) on the Web UI then there should be some way to log them as well.

c-ip s-ip date time time-taken cs-method cs-uri sc-status sc-comment bytes

1 - 2

Post Details

Added on May 27 2020
2 comments
319 views