13.7.2.8 pyqRevoke Function (Autonomous AI Database)
This topic describes the pyqRevoke function when used in
Oracle Autonomous AI 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;
/