9.6.2.2 rqRevoke Procedure
The rqRevoke
procedure revokes read privilege access to an OML4R datastore or to a script in the OML4R script repository.
Syntax
rqRevoke (
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 a script, the type is rqscript. |
V_USER |
The name of the user from whom to revoke access. |
Example 9-30 Revoking Read Access to a Script
-- Revoke read privilege access to OMLUSER.
BEGIN
rqRevoke('myRandomRedDots2', 'rqscript', 'OMLUSER');
END;
/
Parent topic: Embedded R Execution Functions (Autonomous Database)