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
Maintenance Plan Utilities. The objects in this package are used used to set/update/delete maintenance plans in CDB$ROOT by user with the EXECUTE_CATALOG_ROLE role.
A maintenance plan can be queried in a PDB via the DB_NOTIFICATIONS view by a user that has the SELECT_CATALOG_ROLE system privilege or the MAINTPLAN_APP system privilege.
AUTHID
CURRENT_USER
Constants
Name
Data Type
Value
General: Section 1
ACTUAL_ENDTM
VARCHAR2(64)
'actualEndDate'
ACTUAL_STARTM
VARCHAR2(64)
'actualStartDate'
ADDITIONALDATA
VARCHAR2(64)
'additionalData'
DBID
VARCHAR2(64)
'DBID'
DB_UNIQUE_NAME
VARCHAR2(128)
'DB_UNIQUE_NAME'
EXPECTED_ENDTM
VARCHAR2(64)
'expectedEndDate'
EXPECTED_STARTM
VARCHAR2(64)
'expectedStartDate'
INSTANCES
VARCHAR2(64)
'instances'
MAINT_DESC
VARCHAR2(64)
'description'
MAINT_PRODUCT
VARCHAR2(64)
'maintenanceProduct'
MAINT_STATUS
VARCHAR2(64)
'maintenanceStatus'
MAINT_TYPE
VARCHAR2(64)
'maintenanceType'
PATCHID
VARCHAR2(64)
'patchID'
PDBS
VARCHAR2(64)
'pdbs'
PLAN_JSON_DOC
VARCHAR2(64)
'planJsonDoc'
UPDATE_TYPE
VARCHAR2(64)
'updateType'
General: Section 2
NOTIFICATION_TIME
VARCHAR2(64)
'notificationTime'
NOTIFICATION_TYPE
VARCHAR2(64)
'notificationType'
STATUS
VARCHAR2(64)
'status'
General: Section 3
DEFAULT_DATEFORMAT
VARCHAR2(64)
'MM/DD/YYYY HH24:MI:SS TZH:TZM'
General: Section 4
STATUS_PENDING
NUMBER
1
STATUS_RESOLVED
NUMBER
2
STATUS_OBSOLETE
NUMBER
3
Data Types
SQL> desc plan_params
Name Type
----------------- -------------
NOTIFICATION_TYPE VARCHAR2(64)
NOTIFICATION_TIME VARCHAR2(64)
STATUS VARCHAR2(64)
PLANJSONTYPE CHAR(1)
PLANJSONDOC CLOB
METHOD
------
FINAL CONSTRUCTOR FUNCTION PLAN_PARAMS RETURNS SELF AS RESULT
METHOD
------
MEMBER PROCEDURE SET_PARAM
Argument Name Type In/Out
------------------------------ ----------------------- ------
PARAM VARCHAR2 IN
PARAM_VAL VARCHAR2 IN
METHOD
------
MEMBER FUNCTION GET_PARAM RETURNS VARCHAR2
Argument Name Type In/Out
------------------------------ ----------------------- ------
PARAM VARCHAR2 IN
Dependencies
DB_NOTIFICATIONS
DBMS_SYS_ERROR
MAINTPLAN_SEQ
DBMS_OUTPUT
JSON_ELEMENT_T
PLAN_PARAMS
DBMS_SQL
JSON_OBJECT_T
PLITBLM
Documented
No
First Available
20c
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Related privileges include SELECT_CATALOG_ROLE and the MAINTPLAN_APP system privilege.