# How to Use the Audit Feature in Toad for Oracle

**URL:** <https://forums.toadworld.com/t/how-to-use-the-audit-feature-in-toad-for-oracle/61396>\
**Category:** Toad for Oracle - Beta\
**Created:** [October 30, 2025, 3:54am UTC](https://forums.toadworld.com/t/how-to-use-the-audit-feature-in-toad-for-oracle/61396 "2025-10-30T03:54:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sarahwang](https://avatars.discourse-cdn.com/v4/letter/s/ba8739/32.png) [@sarahwang](https://forums.toadworld.com/u/sarahwang)\
**Post date:** [October 30, 2025, 3:54am UTC](https://forums.toadworld.com/t/how-to-use-the-audit-feature-in-toad-for-oracle/61396/1 "2025-10-30T03:54:51Z")

</div>

Hi experts,

I’m using **Toad for Oracle version 17.1.717.3711**.

I’ve enabled auditing for the table **HR.CANDIDATES** with the following settings:

```sql
ALTER SYSTEM SET audit_trail = DB, EXTENDED SCOPE = SPFILE;
AUDIT SELECT, INSERT, UPDATE, DELETE ON hr.candidates BY ACCESS;

```

When users **AMY** and **MARK** select data from `HR.CANDIDATES`, I can see the records in `DBA_AUDIT_TRAIL`.

However, I’m not sure how to properly use the **Audit** features in Toad — such as **Audit Objects** , **Audit SQL/Sys Privs** , and **Audit Policies**.  
I always see the message _“Auditing is not enabled”_ under **Audit Objects**.

Could you please explain how to use these audit features in Toad?  
For example, where can I view the records showing that **AMY** and **MARK** have executed `SELECT` statements on the table?  
The **User Guide** doesn’t provide much detail, so a simple example would be very helpful.

 ![001](https://global.discourse-cdn.com/quest/original/3X/7/c/7cb90e1acbf1285654603f874c96a6b62e6f3e1f.png)

 ![002](https://global.discourse-cdn.com/quest/original/3X/a/4/a4577285904e1e8ea19287f99028806270c5fe67.png)

 ![003](https://global.discourse-cdn.com/quest/original/3X/0/4/041394655717956a9e2b03762c7e253f30f67a4a.png)

 ![004](https://global.discourse-cdn.com/quest/original/3X/3/6/363fa1e6d65b9fe0d70059e59147846aaae40f1c.png)

 ![005](https://global.discourse-cdn.com/quest/original/3X/f/5/f57d9c33cbe08b38a0a91ffa5abd48620adbcc55.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [October 30, 2025, 12:22pm UTC](https://forums.toadworld.com/t/how-to-use-the-audit-feature-in-toad-for-oracle/61396/2 "2025-10-30T12:22:22Z")

</div>

The message "Auditing is not enabled" appears when auditing is disabled in the database. This is the query we run to find that setting.

select value  
from v$parameter  
where name = 'audit\_trail';

The result can be NONE, DB, TRUE, DB\_EXTENDED, or OS. Here is the Oracle documentation about that parameter. [AUDIT\_TRAIL](https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/AUDIT_TRAIL.html)

Did you restart the database after changing the audit\_trail parameter? I think that is needed for the query result to change.

You can see in your last screenshot the effect of `AUDIT SELECT, INSERT, UPDATE, DELETE ON hr.candidates BY ACCESS;` (where you see 'A/A' for that table)

I guess you know, but maybe not - the above (and windows/settings in Toad that you are looking at) is what Oracle calls "Traditional Auditing". Oracle is moving away from Traditional Auditing in favor of the new Unified Auditing.

> **[Security Guide](https://docs.oracle.com/en/database/oracle/oracle-database/26/dbseg/introduction-to-auditing.html#GUID-94381464-53A3-421B-8F13-BD171C867405)**
>
> Oracle AI Database provides the industry’s most comprehensive auditing capability, enabling the capture of detailed information relating to who, what, when the action was performed, and the associated context with the activity which generated the...

You probably have some unified audit policies already set up and working on your database. You might want use/create some of those instead of traditional auditing.
