Database Administration (MOSC)

MOSC Banner

Question regarding audit trail.

edited Aug 16, 2019 5:02AM in Database Administration (MOSC) 3 commentsAnswered

Dear All,

We have enabled Audit in Oracle EBS database. Whenever user connects the database using toad or sql developer to access the database below mentioned sql queries are fired which even they are not aware off. Can you please help in determining where this sql comes from.

Details of audit records.

USERNAME EXTENDED_TIMESTAMP OWNER OBJ_NAME ACTION_NAME SQL_TEXT

QA_OPERATIONS 14-JUN-19 12.37.39.704258000 PM ASIA/CALCUTTA qa.ops LINK$ SELECT "Select owner, object_type from sys.DBA_OBJECTS where object_name = :ObjName  and owner = :OwnerName order by 2 DESC "

QA_OPERATIONS 14-JUN-19 11.49.11.156475000 AM ASIA/CALCUTTA qa.ops LINK$ SELECT "Select object_name from sys.DBA_OBJECTS where owner = 'SYS' and   object_type = 'PACKAGE' and object_name in ('DBMS_JAVA', 'DBMS_DEBUG', 'DBMS_DEBUG_JDWP', 'DBMS_PROFILER') "

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center