powered by Jive Software

Oracle Privileges?

Does anyone know where I can find out what privileges have to be given to the Oracle database user account which Openfile uses to connect to the database?

Obviously it needs CREATE SESSION, and I suppose it needs CREATE TABLE too so as to run the openfire_oracle.sql script. But does it need anything else? I have to give it the minimum necessary, it’s a security requirement.

I’m using version 3.3.2 in case that makes any difference.



as Openfire uses only generic SQL commands INSERT, UPDATE and DELETE should be fine. If you create and update the tables for Openfire during installation, installation of plugins and updates then Openfire does not need the CREATE TABLE right.