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

    ORDS SQL DEVELOPER WEB Audit Logs

    4234270

      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