A Mapping Graph Server Roles to Default Privileges

Installing the PL/SQL packages of the Oracle Graph Server and Client distribution on the target Oracle Database, automatically creates the following roles and assigns the default permissions as shown in the following table:

Table A-1 Mapping Graph Server Roles to Default Privileges

Roles Description Permission
GRAPH_ADMINISTRATOR User who performs operations on the graph server (PGX) using the Java API. (As compared to running start and stop operations as an OS user.)
  • PGX_SESSION_CREATE
  • PGX_SERVER_GET_INFO
  • PGX_SERVER_MANAGE
GRAPH_DEVELOPER User who creates graphs, publishes graphs, modifies graphs, queries graphs, and views graphs using the Java API or SQLcl or the graph visualization application.
  • PGX_SESSION_CREATE
  • PGX_SESSION_NEW_GRAPH
  • PGX_SESSION_GET_PUBLISHED_GRAPH
  • PGX_SESSION_MODIFY_MODEL
  • PGX_SESSION_READ_MODEL
GRAPH_USER User who queries graphs and views graphs Java API or SQLcl or the graph visualization application.
  • PGX_SESSION_CREATE
  • PGX_SESSION_GET_PUBLISHED_GRAPH