Login  Register

Finding dropped users

classic Classic list List threaded Threaded
2 messages Options Options
Embed post
Permalink
ZT
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Finding dropped users

ZT
1 post
Hi Erman,

Given that flashback is not enabled in the Oracle db, and AUDIT_TRAIL is equal to OS meaning audit logs are not available,

if some users were dropped without CASCADE option, for auditing purposes how to find later which users were dropped ?

There is also no result from this query:
SELECT OWNER, ORIGINAL_NAME, TYPE, DROPTIME
FROM DBA_RECYCLEBIN;

Good evening
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Finding dropped users

ErmanArslansOracleBlog
Administrator
5727 posts
That's an audit issue.

if it s set to OS; it directs all audit records to an operating system file. So it is not disabled ZT.