Oracle ID Permissions

Openfire Openfire Support
1

I just started a new install using Oracle 9i R2 as the database.

I have an ID on the database with connect and read/write.

When I try to setup the initial JDBC connection - I receive this error:

The Jive Messenger database schema does not appear to be installed. Follow the installation guide to fix this error[/b].

and in info.log I see:

Found old database schema (2.0). Upgrading to latest schema.[/b]

So I’'m thinking that I need more permissions on my oracle ID?

Do I only needs extra permissions for the install and/or future upgrades?

Thanks.

2

Hi Tom,

You will also want to grant CREATE and UPDATE permissons to your Oracle ID.

Hope that helps,

Ryan