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

Creating 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 10GB 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, refer to appendix, "Database Reference" to determine the quota required for an 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