| 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 Usenet
Received on Fri Oct 24 1997 - 00:00:00 CDT
![]() |
![]() |