9.45 OPG_APIS.GRANT_ACCESS
Format
OPG_APIS.GRANT_ACCESS( graph_owner IN VARCHAR2, graph_name IN VARCHAR2, other_user IN VARCHAR2, privilege IN VARCHAR2);
Description
Grants access privileges on a property graph to another database user.
Parameters
- graph_owner
-
Owner of the property graph.
- graph_name
-
Name of the property graph.
- other_user
-
Name of the database user to which on e or more access privileges will be granted.
- privilege
-
A string of characters indicating privileges:
R
for read,S
for select,U
for update,D
for delete,I
for insert,A
for all. Do not use commas or any other delimiter.If you specify
A
, do not specify any other values becauseA
includes all access privileges.
Usage Notes
(None.)
Examples
The following example grants read and select (RS
) privileges on the mypg
property graph owned by database user SCOTT to database user PGUSR. It then connects as PGUSR and queries the mypg
vertex table in the SCOTT schema.
CONNECT scott/<password> EXECUTE OPG_APIS.GRANT_ACCESS('scott', 'mypg', 'pgusr', 'RS'); CONNECT pgusr/<password> SELECT count(1) from scott.mypgVT$; 17
Parent topic: OPG_APIS Package Subprograms