CA Strong Authentication Windows Installation Guide › How to Configure the Database Server › Oracle Database Configuration › Create a Database

Create a Database

Create a database to store information in the UTF-8 character set. This allows CA Strong Authentication to use international characters including double-byte languages.

Follow these steps:

1. Log in to the Oracle database server as SYS or SYSTEM.
2. Run the following command:

   Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';
   

3. Restart the database, and check whether the character set is configured to UTF-8.
4. Create a user (the recommended name is arcotuser) in the new database arcotdb.
5. Set the quota of user to at least 5 to 10 GB for a development or test deployment, which is primarily used for audit logs.

   Note: If the deployment is for production, staging, or other intensive testing, see appendix, "Database Reference" to determine the quota required for a user.

6. Grant the user the following privileges:

   CREATE TABLE
   

   CREATE INDEX
   

   CREATE SEQUENCE
   

   CREATE PROCEDURE
   

   CREATE SESSION
   

   DML PRIVILEGES
   

    RESOURCE PRIVILEGES
   

   CONNECT PRIVILEGES
   

   ALTER TABLE
   

   • Additional privileges for upgrade only:

      ALTER EXTENT PARAMETERS
     

      CREATE TABLESPACE
     

   • Additional privileges for working with reports:

     UNLIMITED TABLESPACE
     

     (Optional) DROP TABLESPACE