8.1.2 Privileges for Working with PG Views

Learn about the privileges that are required for working with property graph views (PG Views).

In order to create PG Views, ensure that you have the following privileges:

CREATE SESSION
CREATE TABLE
CREATE VIEW

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

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW TO <graphuser>

Or they can be granted indirectly through an appropriate role:

GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW TO GRAPH_DEVELOPER

For loading a PG View 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 PG View graph.

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