Policy Server Administration Guide › Policy Server Tools › Delete SiteMinder Data in ODBC Databases

Delete SiteMinder Data in ODBC Databases

SOA Security Manager provides SQL scripts that delete the SOA Security Manager schema from ODBC databases. The following list describes each SQL script:

• sm_oracle_ps_delete.sql

  Removes the SOA Security Manager 6.x policy store and data from an Oracle database.

• sm_oracle_logs_delete.sql

  Removes SOA Security Manager 6.x logs stored in an Oracle database if the database was created using sm_oracle_logs.sql.

• sm_oracle_ss_delete.sql

  Removes the SOA Security Manager 6.x Session Server tables and data from an Oracle database.

• sm_mssql_ps_delete.sql

  Removes the SOA Security Manager 6.x policy store and data from an SQL database.

• sm_mssql_logs_delete.sql

  Removes SOA Security Manager 6.x logs stored in an SQL database if the database was created using sm_mssql_logs.sql.

• sm_mssql_ss_delete.sql

  Removes the SOA Security Manager 6.x Session Server tables and data from a SQL database.

• sm_db2_ps_delete.sql

  Removes the SOA Security Manager 6.x policy store and data from a DB2 database.

• sm_db2_logs_delete.sql

  Removes SOA Security Manager 6.x logs stored in a DB2 database if the database was created using sm_db2_logs.sql.

• sm_db2_ss_delete.sql

  Removes the SOA Security Manager 6.x Session Server tables and data from a DB2 database.

The ODBC database SQL scripts are in the following location:

• (Windows) siteminder_home\db
  • siteminder_home

    Specifies the Policy Server installation path.

• (UNIX) siteminder_home/db
  • siteminder_home

    Specifies the Policy Server installation path.

Delete the database objects by running the appropriate SQL script using DB2, SQL Plus for Oracle, or SQL Server Query Analyzer.

Note: For more information about running SQL scripts, see your database documentation.