(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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
Printer-friendly version
Send to friend
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
| Level 0 | No Audit |
| Level 1 | Row-level Audit. Audit only the operation without column details |
| Level 2 | Column-level Audit without Blobs. Audit changes to the data at the column level but without Blob changes |
| Level 3 | Full Audit. Audit changes to the data at the column level including Blob changes (Oracle only |
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.
Email: PPadmin@planningplanet.com
Replies