Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL SUCCESSFUL Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: SUCCESSFUL

Definition:
In Oracle PL/SQL, the SUCCESSFUL keyword is used for auditing of successful and unsuccessful operations through the AUDIT statement. The AUDIT statement is used to analyze the impact of SQL statements on subsequent sessions. A SQL statement can be set for audit if it is successful or unsuccessful in a session or by user access. In Oracle PL/SQL, BY SESSION is the default audit mode.

A user must have the AUDIT SYSTEM system privilege to use the AUDIT statement.

Example Syntax:

audit  by session whenever successful;
audit by access whenever not successful;


Example Usage:

The AUDIT statement below audits all successful INSERTS in U1.ORDERS table.

AUDIT INSERT
ON U1.ORDERS
WHENEVER SUCCESSFUL;


The AUDIT statement below audits all unsuccessful SELECT statements on the SCOTT.EMP table.

AUDIT SELECT
ON SCOTT.EMP
WHENEVER NOT SUCCESSFUL;



Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 269 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?