9.5.3 rqGrant Procedure
The rqGrant procedure 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 a script, the type is rqscript.
|
V_USER |
The name of the user to whom to grant access. |
Example 9-21 Granting Read Access to a Script
-- Grant read privilege access to Scott.
BEGIN
rqGrant('myRandomRedDots2', 'rqscript', 'SCOTT');
END;
/Related Topics