
128
|
Oracle DBA Pocket Guide
Security and auditing views
The following views provide information about users, grants,
and security policies that implement FGAC, as well as infor-
mation about the status of Oracle auding and audit trails:
*_SCHEDULER_JOB_RUN_DETAILS
Provides run details for all scheduler jobs.
*_SCHEDULER_JOBS
Lists all scheduler jobs.
*_SCHEDULER_PROGRAM_ARGS
Lists arguments for all scheduler programs.
*_SCHEDULER_PROGRAMS
Lists all scheduler programs.
*_SCHEDULER_RUNNING_JOBS
Lists all running scheduler jobs.
*_SCHEDULER_SCHEDULES
Lists all schedules for the scheduler.
*_SCHEDULER_WINDOW_DETAILS
Lists details for all scheduler windows.
Note that there is no USER_ view.
*_SCHEDULER_WINDOW_GROUPS
Lists all scheduler window groups. Note
that there is no USER_ view.
*_SCHEDULER_WINDOW_LOG
Provides log information for all scheduler
windows. Note thatthere is no USER_view.
*_SCHEDULER_WINDOWS
Lists all scheduler windows. Note that
there is no USER_ view.
*_SCHEDULER_WINGROUP_MEMBERS
Lists the members of all scheduler window
groups. Note that there is no USER_ view.
ALL_DEF_AUDIT_OPTS
Lists the default auditing options in effect for new
objects.
*_APPLICATION_ROLES
Describes all application roles that have
authentication policy roles defined for them. Note
that there is no ALL_ view.
AUDIT_ACTIONS
Lists the audit codes and descriptions.
DBA_AUDIT_EXISTS
Contains audit trail information generated by
AUDIT EXISTS ...