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!

How to find sysdba login history from audit vault

Pronob RoyJun 8 2020

Hi,

Would anyone please help on how can I list the sys user login history from oracle audit vault. I would like to get all login data when a user login as sysdba from database server.

What parameter's should I check?

Following are my audit setting for database.

AUDIT_TRAIL = XML, EXTENDED

AUDIT_SYS_OPERATIONS = TRUE

Database Version: 11g

Thank You.

Comments
Post Details
Added on Jun 8 2020
0 comments
391 views