9.1.2 Privileges for Working with PGQL Property Graphs

Learn about the privileges that are required for working with PGQL property graphs.

In order to create PGQL property graphs, ensure that you have the following privileges:

CREATE SESSION
CREATE TABLE

Note that these privileges can be granted directly to the user:

GRANT CREATE SESSION, CREATE TABLE TO <graphuser>

Or they can be granted indirectly through an appropriate role:

GRANT CREATE SESSION, CREATE TABLE TO GRAPH_DEVELOPER

For loading a PGQL property graph created by another user into the graph server (PGX), you must have:

• SELECT permission on the underlying source database tables or views.
• SELECT permission on the metadata tables used by the PGQL property graph.

  See Table 9-1 and Table 9-2 for more details on the metadata tables.