A.5 rqRevoke Procedure

The rqRevoke procedure revokes read privilege access to an Oracle R Enterprise datastore or to a script in the Oracle Database R 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 Oracle R Enterprise datastore or a script in the Oracle Database R script repository.
V_TYPE For a datastore, the type is datastore; for a script, the type is rqscript.
V_USER The name of the user from whom to revoke access.

Example A-7 Revoking Read Access to a Script

-- Revoke read privilege access to Scott.
BEGIN
  rqRevoke('myRandomRedDots2', 'rqscript', 'SCOTT');
END;
/

Related Topics