ROLE CREATE, ALTER, DROP, or SET a role.
ROLLBACK SEGMENT CREATE, ALTER, or DROP a rollback segment.
SEQUENCE CREATE or DROP a sequence.
SESSION Logons and logoffs.
SYNONYM CREATE or DROP synonyms.
SYSTEM AUDIT AUDIT or NOAUDIT of system privileges.
SYSTEM GRANT GRANT or REVOKE system privileges and roles.
TABLE CREATE, DROP, or TRUNCATE a table.
TABLESPACE CREATE, ALTER, or DROP a tablespace.
TRIGGER CREATE, ALTER (enable/disable), DROP triggers; ALTER TABLE
with either ENABLE ALL TRIGGERS or DISABLE ALL TRIGGERS.
TYPE CREATE, ALTER and DROP types and type bodies.
USER CREATE, ALTER or DROP a user.
VIEW CREATE or DROP a view.
TABLE 9-17 Auditable Statements Included in the ALL Category
334 Oracle Database 11g DBA Handbook
Checking the audit trail in the data dictionary view DBA_AUDIT_TRAIL, we see that
KSHELTON did indeed create an index at 5:15 P.M. on August 12th:
SQL> select username, to_char(timestamp,'MM/DD/YY HH24:MI') Timestamp,
2 obj_name, action_name, sql_text from dba_audit_trail
3 where username = 'KSHELTON';
USERNAME TIMESTAMP OBJ_NAME ACTION_NAME SQL_TEXT
---------- -------------- ---------------- ---------------- ----------------
KSHELTON 08/12/07 17:15 JOB_TITLE_IDX CREATE INDEX create index hr.
job_title_idx on
hr.jobs(job_title)
1 row selected.
Statement Option SQL Operations
ALTER SEQUENCE Any ALTER SEQUENCE command.
ALTER TABLE Any ALTER TABLE command.
COMMENT TABLE Add a comment to a table, view, materialized view, or any of their
columns.
Pages:
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549