Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Catch table droppers
Hi,
Problem:
I wish to trace out the people who drop any table in the Database & store details like username,date of action,... etc in a history table accessible only to me.
" I can't USE the database auditing feature for this purpose since currently our DB is not audited and if I wish to start auditing I need to edit AUDIT_TRAIL , shutdown and startup the databse, which I am strictly porhibited from doing currently." I tried creating Triggers on sys.obj$ as SYS but still it says can't create triggers on objects owned by SYS. Is there any other way ? Thanx.
Platform: Oracle 7.3 on HP-UX 10.20
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Fri Oct 24 1997 - 00:00:00 CDT
![]() |
![]() |