Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Sample User Directories

Sample User Directories

SiteMinder provides schema files that populate a user directory with sample users.

The following schema files are provided in the siteminder_home\db\SQL directory:

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.

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.

Note: Creating a sample user directory is optional. More information on configuring user directory connections to the Policy Server exists in the Policy Server Configuration Guide.

Configure an Oracle Sample User Directory

You configure a sample user directory to populate a database with sample users.

To configure the sample user directory

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/smsampleusers_oracle.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 user directory is populated with the sample users.

3. Configure the user directory connection to the Policy Server.

Note: More information on configuring user directory connections exists in the Policy Server Configuration Guide.

Configure a SQL Server Sample User Directory

You configure a sample user directory to populate a database with sample users.

To configure the sample user directory

1. Open smsampleusers_sqlserver.sql in a text editor and copy the contents of the entire file.
2. Start the Query Analyzer and log in as the user who administers the Policy Server database.
3. Select the database instance from the database list.
4. Paste the schema from smsampleusers_sqlserver.sql into the query.
5. Execute the query.

   The user directory is populated with the sample users.

6. Configure the user directory connection to the Policy Server.

Note: For more information about configuring user directory connections, see the Policy Server Configuration Guide.