Skip to Main Content
  • Questions
  • ORACLE AUDIT FOR DROP AND TRUNCATE TABLE

Breadcrumb

Dev Live Dev Intro

We are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August and September. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, Gyan.

Asked: September 10, 2020 - 4:06 am UTC

Answered by: Connor McDonald - Last updated: September 10, 2020 - 7:03 am UTC

Category: Database Administration - Version: 11.2.0.2

Viewed 100+ times

You Asked

Hi Tom,

I have set the audit trail to db, extended. Then i have enabled the audit for user "test" as "drop any table by test by access". But the audit records for any tables drop by user "test" is not recorded on audit table. Also same for drop procedure, enabled audit trail as "AUDIT drop any procedure BY test BY ACCESS". But the audit record for any packages drop by user "test" is not recorded on audit table. Also i have test the same case on Oracle Version "22.2.0.1", but not working. Is there any other ways to enable the audit for drop/truncate tables, drop packages by specific user only??, please guide us for same.

and we said...

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.