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.
SP2-0808: Package created with compilation warnings
Errors for PACKAGE DBMS_CLOUD_TASK:
LINE/COL ERROR
------------------------------------------------------------------------
1/1 PLW-05018: unit DBMS_CLOUD_TASK omitted optional AUTHID clause;
default value DEFINER used
175/9 PLW-06010: keyword "FORCE" used as a defined name
SP2-0808: Package created with compilation warnings
Session altered.
SQL> @?/rdbms/admin/prvt_cloud_task_body.plb
Session altered.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY DBMS_CLOUD_TASK:
LINE/COL ERROR
------------------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
71/5 PL/SQL: SQL Statement ignored
71/35 PL/SQL: ORA-00942: table or view does not exist
83/3 PL/SQL: Item ignored
86/32 PLS-00201: identifier 'DBMS_CLOUD_TASKS' must be declared
143/3 PL/SQL: Item ignored
146/32 PLS-00201: identifier 'DBMS_CLOUD_TASK_CLASS' must be declared
273/3 PL/SQL: Item ignored
274/32 PLS-00201: identifier 'DBMS_CLOUD_TASKS' must be declared
356/5 PL/SQL: SQL Statement ignored
356/17 PL/SQL: ORA-00942: table or view does not exist
450/5 PL/SQL: SQL Statement ignored
450/17 PL/SQL: ORA-00942: table or view does not exist
486/7 PL/SQL: SQL Statement ignored
486/14 PL/SQL: ORA-00942: table or view does not exist
490/7 PL/SQL: SQL Statement ignored
490/14 PL/SQL: ORA-00942: table or view does not exist
494/7 PL/SQL: SQL Statement ignored
494/14 PL/SQL: ORA-00942: table or view does not exist
514/19 PLS-00201: identifier 'DBMS_CLOUD_TASKS' must be declared
Warning: Package Body created with compilation errors.
dbms_cloud_task.register_task_class(
class_name IN VARCHAR2,
userid IN NUMBER,
task_retention IN INTERVAL DAY TO SECOND,
task_deletion_cbk IN VARCHAR2,
status IN NUMBER);