Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Configure Oracle Data Stores › How to Store Audit Logs in Oracle › Create the Audit Log Schema

Create the Audit Log Schema

You create the audit log schema so the Oracle database can store audit logs.

To create the SiteMinder schema

1. Log into Oracle with sqlplus or some other Oracle utility as the user who administers the Policy Server database information.

   Note: We recommend that you do not create SiteMinder schema with the SYS or SYSTEM users. If necessary, create an Oracle user, such as SMOWNER, and create the schema with that user.

2. Import the following script:

   $NETE_PS_ROOT/db/sql/sm_oracle_logs.sql

   Note: Environment variables may not function in Oracle's SQL utility. If you experience problems importing the script using the utility, specify an explicit path.

   The audit log schema is created in the database.