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
Creates CDB views for all DBA views. Source code is all clear-text.
AUTHID
CURRENT_USER
Dependencies
CDBVIEW_INTERNAL
DBMS_STANDARD
GETLONG
DBMS_APP_CONT_ADMIN
Documented
No
First Available
12.1
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
cdbview.create_cdbview(
chk_upgrd IN BOOLEAN,
owner IN VARCHAR2,
oldview_name IN VARCHAR2,
newview_name IN VARCHAR2);
True indicates the call is part of an upgrade and the views are not recreated. False indicates the call is not part of an upgrade and all CDB views are (re)created.
-- Warning: do not run the following statements ... they are examples found in
-- {ORACLE_HOME}/rdbms/admin files and could be destructive
exec cdbview.create_cdbview(FALSE,'SYS','DBA_CONTEXT','XXX_CONTEXT');
*
ERROR at line 1:
ORA-06550: line 1, column 37:
PLS-00103: Encountered the symbol "SYS" when expecting one of the following:
<an idnetifier> <a double-quoted delimited=identifier>
current delete exists prior