Who/when deleted the Activity

there are 3 levels of auditiing

auditing_enable(<table_name>,<level>)

auditing_disable(<table_name>)

Examples for Oracle:

Enable full auditing on all tables:  exec auditing_enable(null,3);

Enable level one auditing on the task table:  exec auditing_enable('TASK',1);

Disable auditing on PROJWBS: exec auditing_disable('PROJWBS');

Disable auditing on completely:  exec auditing_disable(null);

Example for SQL:

Enable level 2 auditing on the ACCOUNT table:

EXEC auditing_enable

    @ptable_name = N'account',

    @plevel = 2

Use the settings_write_bool procedure to enable the overall auditing feature.

Oracle

exec settings_write_bool(1,'database.audit','Enabled');

SQL Server

exec settings_write_bool 1,'database.audit','Enabled';

Example”

database.audit.PROJWBS.Options=001: Row-level audit on deletes only.

database.audit.TASKRSRC.Options=333: Fully audit.

Dear Zoltan,

Please advise me on how to enadble auditing on Proimavera P6  tables (TASK) (TASKACTV) (TASKRSRC) (TASKFIN) (TRSRCFIN), so that all insert, update, delete are auditied in the (PRMAUDIT) table.

I am using Oracle 10g express edition and ADMPRM$PM logins.

exec auditing_enable(null,3); gives me error = ORA-00900: invalid SQL statement

Please help

Regards

Nauman

try using call or Begin instead of exec