Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Configure an Oracle Policy Store › 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
- On the Oracle global database's configuration screen, select Administration, Users.
- On the Create Tablespaces screen, click Create.
- 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
- Click Roles.
- Select Modify.
- On the Modify Roles screen:
- Select CONNECT and RESOURCE as a roles for this user.
- Click Apply.
- Start sqlplus in a command window, by entering:
- sqlplus
- 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.