You Asked
Hi,
I need your help to find the name of the user who performed DDL on a specific table eg. table emp.
How can i find this ?
Note ,audit is disabled in my db.
os:rhel 6
db:11.2.0.3
and Chris said...
If you've not enabled auditing or created a DDL trigger to capture this the information is gone!
If you want to know who did what, you need to enable auditing.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment