Oracle DBMS_CUBE_PRVTEXP
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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

This package cannot be directly accessed due to an ACCESSIBLE BY clause.
Source {ORACLE_HOME}/olap/admin/olapipexxdb.plb
Subprograms
 
ANC_PATHS_CURSOR_ISOPEN (new 21c)
Undocumented dbms_cube_prvtexp.anc_paths_cursor_isopen RETURN BOOLEAN;
Protected with an ACCESSIBLE with an clause
 
CLOSE_ANC_PATHS_CURSOR (new 21c)
Undocumented dbms_cube_prvtexp.close_anc_paths_cursor;
Protected with an ACCESSIBLE with an clause
 
EXISTSRESOURCE (new 21c)
Undocumented dbms_cube_prvtexp.existsResource(ds_path IN VARCHAR2) RETURN BOOLEAN;
Protected with an ACCESSIBLE with an clause
 
FETCH_ANC_PATHS_CURSOR (new 21c)
Undocumented dbms_cube_prvtexp.fetch_anc_paths_cursor(
ds_anc_path OUT VARCHAR2,
notfound    OUT BOOLEAN);
Protected with an ACCESSIBLE with an clause
 
GET_DS_DOC (new 21c)
Undocumented dbms_cube_prvtexp.get_ds_doc(ds_path IN VARCHAR2) RETURN VARCHAR2;
Protected with an ACCESSIBLE with an clause
 
GET_OBJECT_GRANTS (new 21c)
Undocumented but appears to return

Protected with an an ACCESSIBLE with an 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 PL/SQL 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
 
GET_RESOURCE_NAME (new 21c)
Undocumented dbms_cube_prvtexp.get_resource_name(
ds_path IN VARCHAR2,
ds_doc  IN VARCHAR2)
RETURN VARCHAR2;
Protected with an ACCESSIBLE with an clause
 
OPEN_ANC_PATHS_CURSOR (new 21c)
Undocumented dbms_cube_prvtexp.open_anc_paths_cursor(path IN VARCHAR2);
Protected with an ACCESSIBLE with an clause

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx