Creating an Oracle database for Community Surveys

Manually create the Oracle database for Community Surveys, giving users of the database full administrative permissions.

Procedure

  1. Log in to Oracle SQLPlus using the SYS DBA role.
    Example: sqlplus / as sysdba.
  2. Create three users. Each user is mapped to a schema, where Community Surveys will create tables.

    CREATE USER FREEDOM IDENTIFIED BY <password>;

    CREATE USER IF_CMIS IDENTIFIED BY <password>;

    CREATE USER APP_DATA IDENTIFIED BY <password>;

    Where <password> is an Oracle-accepted password that you create.

  3. Create the administrator role. Community Surveys accesses the Oracle database through a data source. An administrator is required to establish the connection to the database.

    CREATE USER <admin> IDENTIFIED BY <password>;

    Where <admin> is an administrator's user name, and <password> is the administrator's password that you create.

  4. Set the permissions for the administrative user. The following commands grant all permissions and privileges so that the administrative user can access the database.

    GRANT ALL PRIVILEGES TO <admin>;

    GRANT EXECUTE ANY PROCEDURE TO <admin>;

  5. Set table space quotas for the three users of the schemas.

    GRANT UNLIMITED TABLESPACE TO FREEDOM;

    GRANT UNLIMITED TABLESPACE TO IF_CMIS;

    GRANT UNLIMITED TABLESPACE TO APP_DATA;