Oracle

Connecting Crowd to a Database

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

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:

  1. Install the Oracle database server. 

    If you don't already have an operational Oracle server,  download  and install it now. See the  Oracle documentation  for instructions. 

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

    1. 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>;
    2. Grant user permission to connect to the database, create and populate tables:

      grant connect, resource to <user>;
    3. 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>;

Next Steps

Once you've completed the Crowd installation, start Crowd and run the Setup Wizard as described in the Installation Guide.



Last modified on Aug 6, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.