Rem drv: <create type="views" pos="provision/provision_views.sql+"/>
Rem
Rem $Header: audit_views.sql 18-may-2007.12:54:05 pshishir Exp $
Rem
Rem audit_views.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      audit_views.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    pshishir    05/18/07 - 
Rem    gsbhatia    07/01/05 - New repmgr header impl 
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    gsbhatia    02/13/05 - updating repmgr header 
Rem    gsbhatia    02/09/05 - updating repmgr header 
Rem    gsbhatia    02/07/05 - updating repmgr header 
Rem    shianand    02/03/05 - shianand_audit
Rem    shianand    12/21/04 - Created
Rem


CREATE OR REPLACE VIEW MGMT$AUDIT_LOG
AS
SELECT c.user_session_id "CLIENT SESSION ID",
       a.audit_guid, 
       c.em_user "USER NAME",
       c.em_user_type "USER TYPE",
       c.em_user_host_name "CLIENT HOST NAME",
       c.oms_host_name,
       c.time_zone "OMS TIME ZONE",
       c.login_time,
       c.logoff_time,
       c.session_status "LOGON STATUS",
       c.session_type "CLIENT SESSION",
       a.op_code,
       b.operation_description,
       a.object_name,
       a.object_type,
       a.object_owner,
       a.time_stamp,
       c.browser_type "CLIENT TYPE",
       b.operation_audit,
       b.audit_column_name1,
       a.audit_column_value1,
       b.audit_column_name2,
       a.audit_column_value2,
       b.audit_column_name3,
       a.audit_column_value3,
       b.audit_column_name4,
       a.audit_column_value4,
       b.audit_column_name5,
       a.audit_column_value5,
       b.audit_column_name6,
       a.audit_column_value6,
       b.audit_column_name7,
       a.audit_column_value7,
       b.audit_column_name8,
       a.audit_column_value8,
       b.audit_column_name9,
       a.audit_column_value9,
       b.audit_column_name10,
       a.audit_column_value10,
       b.audit_column_name11,
       a.audit_column_value11,
       b.audit_column_name12,
       a.audit_column_value12,
       b.audit_column_name13,
       a.audit_column_value13,
       b.audit_column_name14,
       a.audit_column_value14,
       b.audit_column_name15,
       a.audit_column_value15,
       b.audit_clob_name1,
       a.audit_clob_value1,
       c.ca_name_1,
       c.ca_value_1,
       c.ca_name_2,
       c.ca_value_2,
       c.ca_name_3,
       c.ca_value_3
FROM   mgmt_audit_logs a, mgmt_operations_master b, mgmt_user_session c
WHERE  a.op_code = b.op_code (+) 
AND    a.user_session_id_guid (+) = c.user_session_id_guid
WITH READ ONLY;