13.7.2.8 pyqRevoke Function (Autonomous Database)
This topic describes the pyqRevoke function when used in
Oracle Autonomous Database.
The pyqRevoke function revokes read privilege access to
an OML4Py datastore or to a script in the OML4Py script repository.
Syntax
pyqRevoke (
V_NAME VARCHAR2 IN
V_TYPE VARCHAR2 IN
V_USER VARCHAR2 IN DEFAULT)Parameters
| Parameter | Description |
|---|---|
| V_NAME | The name of an OML4Py datastore or a script in the OML4Py script repository. |
| V_TYPE | For a datastore, the type is
datastore; for script the type is
pyqScript.
|
| V_USER | The name of the user from whom to revoke access. |
Example 13-35 Revoking Read Access to a script
-- Revoke read privilege access to script pyqFun1 from SCOTT.
BEGIN
pyqRevoke('pyqFun1', 'pyqscript', 'SCOTT');
END;
/Example 13-36 Revoking Read Access to a datastore
-- Revoke read privilege access to datastore ds1 from SCOTT.
BEGIN
pyqRevoke('ds1', 'datastore', 'SCOTT');
END;
/Example 13-37 Revoking Read Access to a script from all Users
-- Revoke read privilege access to script pyqFun1 from all users.
BEGIN
pyqRevoke('pyqFun1', 'pyqscript', NULL);
END;
/Example 13-38 Revoking Read Access to a datastore from all Users
-- Revoke read privilege access to datastore ds1 from all users.
BEGIN
pyqRevoke('ds1', 'datastore', NULL);
END;
/