Enabling auditing on an Oracle resource

You must enable auditing on the database so that the Oracle Database Adapter can retrieve the last access date of the user account.

About this task

If auditing is not enabled, the Oracle Database Adapter cannot retrieve the information about when the user last accessed the account.

Procedure

Set the initialization parameter audit_trail to TRUE in the init.ora file.
Alternately, you can issue the following command at the SQL command-line prompt:
```
ALTER SYSTEM SET audit_trail=TRUE scope=SPFILE
```
Restart the database instance.
To turn on the auditing for user logon and logoff, log on as a user with Oracle administration authority. Issue the following command at the SQL command-line prompt:
```
AUDIT CONNECT
```

What to do next

To verify that auditing is enabled on an instance, issue the following command at the SQL command-line prompt:

SHOW PARAMETER AUDIT_TRAIL

The parameter AUDIT_TRAIL and its value are displayed. Any value except NONE or FALSE indicates that auditing is enabled. For more information about the parameters, see the Oracle online help.