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.