My Oracle Support Banner

Error: "SQL Error: ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges"" When Attempting to Establish a P6 DACS Connection (Doc ID 2371713.1)

Last updated on MARCH 22, 2022

Applies to:

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


When trying to create a link to the P6 EPPM DACS connection, the following error occurs:


Error at Command Line:1 Column:29
Error report:
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password without the appropriate privilege. This error occurs if attempting to install a database without the necessary operating privileges.


The issue can be reproduced at will with the following steps:
1. Connect to a local database
2. Run the command to create a public link to the DACS Database.
3. Observe the error.


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

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