ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Undocumented but definitely for OLAP and likely related to cube export.
AUTHID
CURRENT_USER
Dependencies
DBMS_CUBE_EXP
EQUALS_PATH
UNDER_PATH
DBMS_XDB
RESOURCE_VIEW
XMLTYPE
DBMS_ZHELP
Documented
No
First Available
20c
Security Model
Owned with an SYS with EXECUTE granted to PUBLIC
Direct access to this package is prevented by means of an Accessible By clause.
dbms_cube_prvtexp.get_object_grants(
obj_id IN NUMBER,
cascade IN BOOLEAN,
grantor OUT VARCHAR2,
grantee OUT VARCHAR2,
grant_option OUT BINARY_INTEGER,
priv OUT NUMBER,
obj_schema OUT VARCHAR2,
obj_name OUT VARCHAR2,
state IN OUT BOOLEAN);
SELECT object_id
FROM dba_objects
WHERE object_name = 'PDB_ARC_SKIP$';
DECLARE
b BOOLEAN := TRUE;
x NUMBER;
z dbms_id;
BEGIN
dbms_cube_prvtexp.get_object_grants(261, b, z, z, x, x, z, z, b);
dbms_output.put_line(z);
END;
/
dbms_cube_prvtexp.get_object_grants(261, b, z, z, x, x, z, z, b);
*
ERROR at line 6:
ORA-06550: line 6, column 3:
PLS-00904: insufficient privilege to access object DBMS_CUBE_PRVTEXP
ORA-06550: line 6, column 3:
PL/SQL: Statement ignored
