Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(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.

Who/when deleted the Activity

3 replies [Last post]
Tue, 2014-12-16 10:41
Jason LI
User offline. Last seen 4 years 13 weeks ago. Offline
Joined: 1 Jan 2008
Posts: 37
Groups: Petro-Chem / Oil & Gas

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

Top

Replies

Wed, 2015-08-12 12:01
#1
Zoltan Palffy
User offline. Last seen 26 weeks 5 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

try using call or Begin instead of exec

Top
Tue, 2015-08-11 16:21
#2
Nauman Reh
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 6 Mar 2014
Posts: 7
Groups: None

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

Top
Wed, 2014-12-17 18:31
#3
Zoltan Palffy
User offline. Last seen 26 weeks 5 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

there are 3 levels of auditiing

Level 0No Audit
Level 1Row-level Audit. Audit only the operation without column details
Level 2Column-level Audit without Blobs. Audit changes to the data at the column level but without Blob changes
Level 3Full 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.

Top