Configuring the ALI Identity Service Database

This topic describes how to create the AquaLogic Identity Service database.

1. Create the database user and database schema that will contain the ALI Identity Service tables. You will need DBA privileges to perform this step.
   Note: These new user id and password you create must match the ones you specified in the ALI Identity Service Database step of the WorkSpace Extensions configuration wizard.
   For the case of Oracle:
   

   1. You may create the new database user with the following script. Replace aliis_db and password with the ID and password for the new user you want to create:

        create user aliis_db identified by password;
        grant connect to aliis_db;
        grant resource to aliis_db;
        grant create view to aliis_db;
      

   2. You need to have an Oracle tablespace in place where the ALI Identity Service database indexes will be created. A standard installation of ALI defines a "PLUMINDEX" tablespace; you may reuse it for Identity Service. If you don't have a tablespace available, you may create a new one following this example SQL script (assuming the database SID is "PLUM"):

        REM * Create a tablespace for indexes.
        REM *
        CREATE TABLESPACE ALIIS_INDEX
           DATAFILE '$ORACLE_BASE/oradata/PLUM/aliisidx.dbf'
           SIZE 65536K REUSE AUTOEXTEND ON
           EXTENT MANAGEMENT LOCAL AUTOALLOCATE
           SEGMENT SPACE MANAGEMENT AUTO
        ;
      

      On Windows, the DATAFILE path would be:

           DATAFILE '%ORACLE_BASE%\oradata\PLUM\aliisidx.dbf'
      

   3. You must modify the SQL script generated by the WorkSpace Extension Configuration Wizard to specify the right tablespace. In the following line, replace "PROCESSINDEX" with the name of your tablespace:

        DEF IDX_TBSP=PROCESSINDEX
      

      For example, to specify the "PLUMINDEX" tablespace you should change it to:

        DEF IDX_TBSP=PLUMINDEX
      

2. Run the SQL script generated by the WorkSpace Extensions configuration wizard. You should run the script using the id of the user created in the previous steps to ensure the database objects are created on the right schema and namespace.