DELETE TABLE Delete rows from a table or view.
EXECUTE
PROCEDURE
Execute a procedure, function, or any variables or cursors within a
package.
GRANT
DIRECTORY
GRANT or REVOKE a privilege on a DIRECTORY object.
GRANT
PROCEDURE
GRANT or REVOKE a privilege on a procedure, function, or package.
GRANT
SEQUENCE
GRANT or REVOKE a privilege on a sequence.
GRANT TABLE GRANT or REVOKE a privilege on a table, view, or materialized view.
GRANT TYPE GRANT or REVOKE a privilege on a TYPE.
INSERT TABLE INSERT INTO a table or view.
LOCK TABLE LOCK TABLE command on a table or view.
SELECT SEQUENCE Any command referencing the sequence??™s CURRVAL or NEXTVAL.
SELECT TABLE SELECT FROM a table, view, or materialized view.
UPDATE TABLE Execute UPDATE on a table or view.
TABLE 9-18 Explicitly Specified Statement Types
Chapter 9: Database Security and Auditing 335
NOTE
Starting with Oracle Database 11g, the columns SQL_TEXT and SQL_
BIND in DBA_AUDIT_TRAIL are populated only if the initialization
parameter AUDIT_TRAIL is set to DB_EXTENDED. By default, the
value of AUDIT_TRAIL is DB.
To turn off auditing for KSHELTON on the HR.JOBS table, we use the noaudit command, as
follows:
SQL> noaudit index by kshelton;
Noaudit succeeded.
We also may wish to routinely audit both successful and unsuccessful logins. This requires
two audit commands:
SQL> audit session whenever successful;
Audit succeeded.
SQL> audit session whenever not successful;
Audit succeeded.
Pages:
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550