Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Create a Sample User Directory for Oracle or SQL Server

Create a Sample User Directory for Oracle or SQL Server

SiteMinder provides schema files to create sample users to populate a user directory for the Policy Server. The following schema files are provided in the \siteminder\db\Sql directory:

smsampleusers_oracle.sql

Creates the schema for SiteMinder sample users in an Oracle database and populates the database with sample users. For example, if you look in the script, you can see a sample user named GeorgeC with a password of siteminder.

smsampleusers_sqlserver.sql

Creates the schema for SiteMinder sample users in a SQL Server database and populates the database with sample users. For example, if you look in the script, you can see a sample user named GeorgeC with a password of siteminder.

Note: These user directories are optional since your environment will have different ones.

Create the database objects by running the appropriate SQL script(s) using SQL Plus for Oracle or the SQL Server Enterprise Manager and SQL Server Query Analyzer.

Note: For information about running SQL scripts, refer to your database documentation.

More Information:

Delete SiteMinder Data in ODBC Databases