RF Campus Security Audit Report (Campus Security Administrators Only)

Description

Purpose

The Research Foundation developed this customized security report to ensure access is controlled, accurate and to help avoid misuse. The RF Campus Security Audit report is provided as a tool for the Campus Administrator and should be used to monitor security administrator activity in the Oracle application (i.e. changes made to user access in the business applications). This report documents security changes made in the Oracle application and should be reviewed to determine if changes made were appropriate by following proper procedures. If an unauthorized change was made, campus management should be informed immediately as well as central office Information Security.

Frequency

The above report is required to be reviewed daily.

Responsibilities with Access

People with the following responsibilties are able to run this report:

ORG Campus Security
RUSAM Central Security Admin
CO System Administrator
System Administrator

Setting Report Parameters

The following table describes the required and optional parameters to use to run the report:


Parameter	Description (click in the field to see the List of Values)
Required Parameters
From Location		The location in which the data will be reported on.
To Location		The location in which the data will be reported on.
User		Display results for specific user.
From Date		The date from which the data will be reported on.
To Date		The current date from which the data will be reported to.

Instructions to Run Report

Step	Action
1	From the applicable responsibility in the Navigator window, select Reports > Run.
2	Select Single Request.
3	Click OK to go to the Submit Request form.
4	Complete the following field: Name (Title of the report to be run. Select from the list of values).
5	The parameters form will be displayed if you select a request that requires parameter values. As required, enter the parameters.
6	Click OK to return to the Submit Request form.
7	Click Submit to go to the Requests form.
8	Once the report has finished running, click View Output. You will be able to view your report in PDF format.

Understanding the Output

The table that follows describe the report output:

Column Heading	Description of Column
Action	Action that was performed (i.e. update, delete, add)
Action Description	The description of what was actually updated, added or deleted (i.e. changed employee id, reset password, etc.).
Application User Name	The full name of the user account that was modified (Last Name, First Name).
Change Time	Date and Time the modification was made on the user record.
Value Before	Value before it was changed.
Value After	Value after it was changed.

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
Once you select a format and run the report, you cannot change the output format. You will need to run the report again and select the desired output format on the Submit Request window.