Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PGX 21.3 PgxFileLocationResource Authorization

Cgbulee-OracleAug 1 2021

Installed 21.3 Graph Server Linux 7 (rpm), running opg-jshell
Following example here: https://docs.oracle.com/cd/E56133_01/latest/getting-started/quickstart.html
Added vertices.csv and edges.csv to ..oracle/graph/data/samples and gave 777 permissions to oraclegraph, added user llatham to oraclegraph group
/opt/oracle/graph $ ./bin/opg-jshell --base_url http://localhost:7007 -u llatham
password: ******
For an introduction type: /help intro
Oracle Graph Server Shell 21.3.0
Variables instance, session, and analyst ready to use.
opg4j> session.readGraphFiles("../data/samples/vertices.csv", "../data/samples/edges.csv", "LoadedGraphName");
18:13:53,045 ERROR PgxRemoteFuture - caught exception
oracle.pgx.common.auth.AuthorizationException: PgxUser(LLATHAM) has insufficient privileges on PgxFileLocationResource{file:/opt/oracle/graph/data/samples/vertices.csv} code: PGX-ERROR-3VW2PK0CNN9VN
at oracle.pgx.common.marshalers.ExceptionMarshaler.toUnserializedException(ExceptionMarshaler.java:107) ~[pgx-api-21.3.1.jar:21.3.1]
Database privileges are set and working with pgql.
What additional permission is needed? Is this required in pgx.conf? What is the syntax?

Comments

Post Details

Added on Aug 1 2021
10 comments
483 views