2 Replies Latest reply on May 28, 2020 5:07 AM by 4234270

ORDS SQL DEVELOPER WEB Audit Logs

4234270 May 27, 2020 9:29 AM

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

Screenshot 2020-05-27 at 2.29.58 PM.png 422.1 K

1. Re: ORDS SQL DEVELOPER WEB Audit Logs

thatJeffSmith-Oracle May 27, 2020 1:11 PM (in response to 4234270)

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
Like Show 0 Likes(0)

Actions

2. Re: ORDS SQL DEVELOPER WEB Audit Logs

4234270 May 28, 2020 5:07 AM (in response to thatJeffSmith-Oracle)

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

Go to original post