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 188.8.131.52 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
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