CA AuthMinder UNIX Installation Guide › Preparing for Installation › Configuring Database Server › Oracle Database Configuration › Create a Database User

Create a Database User

Create a user with the following criteria:

1. Create a user (the recommended name is arcotuser) in the new database arcotdb.
2. 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.

3. 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