Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › How to Configure a SiteMinder Data Store in an Oracle Database › Prerequisites for an Oracle 10g Database › Create an Oracle 10g User to Manage the Policy Store’s Table Space

Create an Oracle 10g User to Manage the Policy Store’s Table Space

Creating a user to manage table space for the policy store is a prerequisite for an Oracle 10g database only.

To create a user to manage table space for the policy store

1. On the Oracle global database’s configuration screen, select Administration, Users.
2. On the Create Tablespaces screen, click Create.
3. On the Create User screen, enter the:
   • Name for the user.

     Example: NETE

   • Password for the user.
   • Default Tablespace that you created.
   • Temporary tablespace.

     Example: TEMP

4. Click Roles.
5. Select Modify.
6. On the Modify Roles screen:
   1. Select CONNECT and RESOURCE as a roles for this user.
   2. Click Apply.
7. Start sqlplus in a command window, by entering:
   1. sqlplus
   2. the credentials for the policy store user created on the Create User screen.

   You have completed the prerequisites for an Oracle 10g database, and can now configure a SiteMinder data store for the database.

More Information:

Create an Oracle Database With SiteMinder Schema