Error: "The select permission was denied on the object 'ADMIN_CONFIG', database 'PMDB, Schema 'privuser'." When Attempting to Login to P6 Professional, Connecting to a SQL Server Database. (Doc ID 2078445.1)

Last updated on MARCH 30, 2017

Applies to:

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

Symptoms

When attempting to login to P6 Professional, connecting to a SQL Server database, the following error occurs:

ERROR
-----------------------
The select permission was denied on the object 'ADMIN_CONFIG', database 'PMDB, schema 'privuser'.

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot login to P6 Professional.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms