Some examples will help make all these options a lot clearer. In our sample database, the user
KSHELTON has privileges on all of the tables in the HR schema and other schemas. KSHELTON
is allowed to create indexes on some of these tables, but we want to know when the indexes are
created in case we have some performance issues related to execution plans changing. We can
audit index creation by KSHELTON with the following command:
SQL> audit index by kshelton;
Audit succeeded.
Later that day, KSHELTON creates an index on the HR.JOBS table:
SQL> create index job_title_idx on hr.jobs(job_title);
Index created.
Chapter 9: Database Security and Auditing 333
Statement Option SQL Operations
ALTER SYSTEM All ALTER SYSTEM options such as dynamically altering
instance parameters, switching to the next log file group, and
terminating user sessions.
CLUSTER CREATE, ALTER, DROP, or TRUNCATE a cluster.
CONTEXT CREATE or DROP a CONTEXT.
DATABASE LINK CREATE or DROP a database link.
DIMENSION CREATE, ALTER, or DROP a dimension.
DIRECTORY CREATE or DROP a dimension.
INDEX CREATE, ALTER, or DROP an index.
MATERIALIZED VIEW CREATE, ALTER, or DROP a materialized view.
NOT EXISTS Failure of SQL statement due to nonexistent referenced objects.
PROCEDURE CREATE or DROP FUNCTION, LIBRARY, PACKAGE, PACKAGE
BODY, or PROCEDURE.
PROFILE CREATE, ALTER, or DROP a profile.
PUBLIC DATABASE LINK CREATE or DROP a public database link.
PUBLIC SYNONYM CREATE or DROP a public synonym.
Pages:
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548