Skip to Main Content
Forums

Oracle Database Discussions

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!

Find out timestamp of drop user

1043868Mar 20 2014 — edited Mar 20 2014

Hi All,

Interested to know how to find out the details like when and who drop a user from an ORACLE database.

For example, we have a database of version 11.2.0.2 where audit_trail and audit_sys_operations parameters are set to "DB" and "TRUE" respectively.

Now if somebody drop a user , we want to know who is that somebody and when the user was dropped.

Thanks in advance ..!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2014
Added on Mar 20 2014
#audit, #general-database-discussions
11 comments
1,549 views