Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843