Skip to Main Content

Database Software

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!

All users DB login information

2635384Mar 20 2014 — edited Mar 22 2014

Hi All,

We are using Oracle 10g and we enabled the auditing,

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB

But we are not getting all users login information in DBA_AUDIT_TRAIL and sys.aud$.

There are information for some users but not for all users. Is it mean that other user are not audited.

How do we find user list which are currently audited.

Thanks !

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2014
Added on Mar 20 2014
12 comments
5,477 views