Database Administration (MOSC)

MOSC Banner

11.2 database audit

edited May 12, 2017 12:46AM in Database Administration (MOSC) 5 commentsAnswered

select distinct user_name from dba_stmt_audit_opts returns following users :

USER_NAME

-------------------------

SYSTEM

DBOPR

However when I query dba_audit_trail  for select statements executed yesterday, I see following user

USERNAME    ACTION_NAME   TIMESTAMP

-----------------    ---------------------    ------------------

APPSUSER1   SELECT               16-APR-17

APPSUSER1   SELECT               16-APR-17

APPSUSER1   SELECT               16-APR-17

Which view other than dba_stmt_audit_opts would contain information about appsuser1.

Tagged:

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center