SQL> insert into hr.jobs (job_id, job_title, min_salary, max_salary)
2 values ('OE_VLD','Order Entry CC Validation', 5500, 20000);
1 row created.
Object Option Description
ALTER Alters a table, sequence, or materialized view
AUDIT Audits commands on any object
COMMENT Adds comments to tables, views, or materialized views
DELETE Deletes rows from a table, view, or materialized view
EXECUTE Executes a procedure, function, or package
FLASHBACK Performs flashback operation on a table or view
GRANT Grants privileges on any type of object
INDEX Creates an index on a table or materialized view
INSERT Inserts rows into a table, view, or materialized view
LOCK Locks a table, view, or materialized view
READ Performs a read operation on the contents of a DIRECTORY object
RENAME Renames a table, view, or procedure
SELECT Selects rows from a table, view, sequence, or materialized view
UPDATE Updates a table, view, or materialized view
TABLE 9-19 Object Auditing Options
338 Oracle Database 11g DBA Handbook
Looking in the DBA_AUDIT_TRAIL view, we see the two insert commands in KSHELTON??™s
session:
USERNAME TIMESTAMP OWNER OBJ_NAME ACTION_NAME
SQL_TEXT
---------- -------------- -------- ---------- ---------------
---------------------------------------------------------------
KSHELTON 08/12/07 22:54 HR JOBS INSERT
insert into hr.jobs (job_id, job_title, min_salary, max_salary)
values ('IN_CFO','Internet Chief Fun Officer', 7500, 50000);
KSHELTON 08/12/07 22:53 HR JOBS INSERT
insert into hr.
Pages:
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554