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 support utility for Auto Task administration
AUTHID
Definer
Data Types
TYPE window_calendar_entry IS RECORD (
window_name dba_scheduler_windows.window_name%TYPE,
start_time TIMESTAMP WITH TIME ZONE,
duration dba_scheduler_windows.duration%TYPE);
TYPE window_calendar_t IS TABLE OF window_calendar_entry;
TYPE winname_t IS RECORD (
window_name dba_scheduler_windows.window_name%TYPE,
start_date TIMESTAMP WITH TIME ZONE,
end_date TIMESTAMP WITH TIME ZONE);
TYPE refcur_winname_t IS REF CURSOR RETURN winname_t;
Signal an error if the client is overridden to DISABLED even if it is enabled on disk (e.g. pack disabled, underscore parameter, etc). Called to validate an ENABLE operation.
dbms_auto_task.check_client_status_override(client_id IN PLS_INTEGER);
Determine if a given client's status should be overridden to DISABLED even if it is ENABLED on disk (e.g. pack disabled, underscore parameter, etc). A return value of 1 means such an override exists, 0 means it does not.
dbms_auto_task.get_client_status_override(client_id IN PLS_INTEGER)
RETURN PLS_INTEGER;
Compute a list of the task scheduled date provide the start and end dates. taskname is the defined autotask name (used by EM)
dbms_auto_task.get_schedule_date(
taskname IN VARCHAR2,
start_date IN TIMESTAMP WITH TIME ZONE,
end_date IN TIMESTAMP WITH TIME ZONE,
scheduled_list OUT ket$_window_list);
Combines supplied attribute flag sets into a single set of attribute flags. Arguments listed in order of descending priority. I.e. ask_rep_attr settings, if any, override all of the other settings.
dbms_auto_task.reconcile_attributes(
cli_comp_attr IN NUMBER DEFAULT 0, -- client compile-time attributes
cli_rep_attr IN NUMBER DEFAULT 0, -- client repository attributes
op_comp_attr IN NUMBER DEFAULT 0, -- operation compile-time attributes
op_rep_attr IN NUMBER DEFAULT 0, -- operation repository attributes
task_comp_attr IN NUMBER DEFAULT 0, -- task client-defined attributes
task_rep_attr IN NUMBER DEFAULT 0) -- task repository override attributes
RETURN NUMBER;