When you run the Crowd Setup Wizard, you will be asked to choose a database and provide configuration settings for that database. For smoother setup process, we recommend that you create the database and deploy the database driver before you start the Crowd Setup Wizard.
To prepare Oracle for Crowd:
- Install the Oracle database server.
Create an Oracle database user.
It is recommended to create a separate database user for Crowd to use. Connecting as the SYS user is not supported.
Create a database user which Crowd will connect as (e.g. crowduser):
create user <user> identified by <password> default tablespace <tablespace_name> quota unlimited on <tablespace_name>;
Grant user permission to connect to the database, create and populate tables:
grant connect, resource to <user>;
Ensure that the user has the following privileges:
grant connect to <user>; grant create table to <user>; grant create sequence to <user>; grant create trigger to <user>;
Once you've completed the Crowd installation, start Crowd and run the Setup Wizard as described in the Installation Guide.