rqGrant Function

9.6.2.1 rqGrant Function

This topic describes the rqGrant function when used in Oracle Autonomous Database.

The rqGrant function grants read privilege access to an OML4R datastore or to a script in the OML4R script repository.

Syntax

rqGrant (
    V_NAME          VARCHAR2    IN
    V_TYPE          VARCHAR2    IN
    V_USER          VARCHAR2    IN     DEFAULT)

Parameters

Parameter	Description
V_NAME	The name of an OML4R datastore or a script in the OML4R script repository.
V_TYPE	For a datastore, the type is `datastore`; for script the type is `rqScript`.
V_USER	The name of the user to whom to grant access.

Example 9-26 Granting Read Access to a script

-- Grant read privilege access to OMLUSER.
BEGIN
  rqGrant('RandomRedDots2', 'rqscript', 'OMLUSER');
END;
/

Example 9-27 Granting Read Access to a datastore

-- Grant read privilege access to datastore ds1 to OMLUSER.
BEGIN
  rqGrant('ds1', 'datastore', 'OMLUSER');
END;
/

Example 9-28 Granting Read Access to a Script to all Users

-- Grant read privilege access to script RandomRedDots to all users.
BEGIN
  rqGrant('rqFun1', 'rqscript', NULL);
END;
/

Example 9-29 Granting Read Access to a datastore to all Users

-- Grant read privilege access to datastore ds1 to all users.
BEGIN
  rqGrant('ds1', 'datastore', NULL);
END;
/

Parent topic: Embedded R Execution Functions (Autonomous Database)