13.6.7 pyqRevoke Function (On-Premises Database)
This topic describes the pyqRevoke function when used in an
on-premises Oracle 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-25 Revoking Read Access to a script
-- Revoke read privilege access to script pyqFun1 from SCOTT.
BEGIN
pyqRevoke('pyqFun1', 'pyqscript', 'SCOTT');
END;
/Example 13-26 Revoking Read Access to a datastore
-- Revoke read privilege access to datastore ds1 from SCOTT.
BEGIN
pyqRevoke('ds1', 'datastore', 'SCOTT');
END;
/Example 13-27 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-28 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;
/