10.5.5 rqRevoke Procedure
The rqRevoke procedure revokes 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 a script, the type is rqscript. |
V_USER |
The name of the user from whom to revoke access. |
Example 10-23 Revoking Read Access to a Script
-- Revoke read privilege access to Scott.
BEGIN
rqRevoke('myRandomRedDots2', 'rqscript', 'SCOTT');
END;
/