D.9 Creating a View in Oracle

To use reports in the Novell Audit Reporting Application (lreport.exe), you must create a view in Oracle as follows:

  1. Log into SQLPLUS as a user with rights to create a view in the Novell Audit database.

  2. Execute the following command:

    create view NAUDITLOG as * from table_name

    The default table name defined by the Oracle channel is NAUDITLOG.

  3. In the Novell Audit Reporting Application, define the default table as NAUDITLOG.

    For more information on this procedure, see Defining Your Default Database and Table .