Primavera (MOSC)

MOSC Banner

P6 Database Configuration - Bad Private Username or Password

in Primavera (MOSC) 2 commentsAnswered
Hi Guys,
I am trying to configure P6 having already installed and have running EPPM.  When I attempt to connect to the database using the pubuser and the correct password the login fails and asks to check public group id.

Users pubuser, privuser and pxrptuser are in the database as logins, users and have schemas.  I have checked passwords.

Initially when trying to use pubuser/PW and public group ID=1 combo it returned the error saying login failed for privuser, not pubuser. 

I then found the PUBUSER table and it initially only had one row, that being for privuser as group ID 1,and the password looking like it is encrypted.  I added a row for pubuser as group ID 2 and the password as human readable.  This allows the config tool to see pubuser but the it still doesn't connect.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center