Finding dropped users

Posted by ZT on Feb 10, 2025; 3:33pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Finding-dropped-users-tp12914.html

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