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.

NOTPRMUSER displaying in P6

2 replies [Last post]
Sasha Mathew
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 19 Aug 2015
Posts: 3
Groups: None

Getting a login of NOTPRMUSER for certain projects.  After reading an article it says this is a hidden generic Oracle account that is used if data is updated directly to the P6 Database in most cases instead of through a P6 module. Has anyone seen this before and had an explanation as to why this happened?

Our database person checked and there is no one who should have direct update access to the database. Version is P6 R8.1

Replies

Sasha Mathew
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 19 Aug 2015
Posts: 3
Groups: None

Thank you.

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

here is my take on it 

this is used to recored an action by the user where the "update_user" or "create_user" column is generated when p6 ties to recored Last Modified By (or Added By) column in the Activities View. 

When an update is made from any P6 module (Project Management, P6 Web Access, API, SDK, etc.) the Last Modified By (update_user) or Added By (create_user) fields are populated with the name of the user that is logged into P6 making the particular update. So even using SDK could cause this.

This can also be seen if

P6 Job Services created/updated this particular record

The "Automatically fix errors" option was used when running Check Project Integrity

The project has been scheduled in P6 Web Access which is a bug 

 

someone could have ran tthe tool to Check Project Integrity