Privileges to Load a SQL Property Graph

Learn about the privileges required to load a SQL property graph into the graph server(PGX).

Ensure that you have the following set of permissions:

• SELECT permission is required for the SQL property graph.

  • If you are the graph owner, you will automatically get this permission.

  • Otherwise, you can grant the permission as shown:

    GRANT SELECT ON PROPERTY GRAPH <graph_name> TO <user_name>;

• SELECT permission is required for all the underlying data tables of the SQL property graph

  • This permission is required to access entity keys.

  • Note that these permissions are handled separately from the graph permissions.

  • You can grant the permission as shown:

    GRANT SELECT ON <table_name> TO <user_name>;