Search code examples
oracle11gaudit-trail

Audit trail setting in oracle 11g

I would like to know how to view the oracle 11g audit setting.

i need to check if it is enabled or not.

I read audit_trail will help but when i run the query "select * from audit_trail" it returns invalid table error.

Solution

  • You can check the audit status via

    SHOW parameter audit_trail

    or

    SELECT name, value FROM v$parameter WHERE name = 'audit_trail';

    if it is set to none then auditing if off, anything else and it is on.

    See here for more information on the choices for this value.