My Oracle Support Banner

"Bad private user name or password. Check the public group ID. SQL State: 5, SQL Error Code: 229, Level 14, Procedure: , Line: 1 The SELECT permission was denied on the object 'PUBUSER', database 'PMDB', schema 'dbo'" When Configuring SQL Server DB (Doc ID 2489503.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.5.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to connect to the SQL Server database, via P6 Professional, the following error occurs.

ERROR

Bad private user name or password. Check the public group ID. SQL State: 5, SQL Error Code: 229, Level 14, Procedure: , Line: 1
The SELECT permission was denied on the object 'PUBUSER', database 'PMDB', schema 'dbo'.

STEPS

The issue can be reproduced at will with the following steps:

  1. Move database from one server to another server.
  2. Run the exec scripts to connect the database login to the database schemas.
  3. Login to P6 Professional once, then consecutive logins fail in "User already logged in."
  4. Attempt to configure the database connection, wizard fails with the reported error.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.