Dear Planners,
In P6, is it possible to know Who deleted the activity, and when deleted it. maybe the activity was deleted few days ago, several planners are working in one schedule.
Thanks for your reply.
BR
Jason
Who/when deleted the Activity
Forum Sponsor
Top Posters
Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
try using call or Begin instead of exec
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
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.