Hi,
I’m using Bonita 7.1.5 Community Edition with an Oracle database.
My company’s Oracle DBA is questioning these privileges (pulled from here: Database Configuration) for the bonita database user:
CREATE USER bonita IDENTIFIED BY bonita;
GRANT connect, resource TO bonita IDENTIFIED BY bonita;
GRANT select ON sys.dba_pending_transactions TO bonita;
GRANT select ON sys.pending_trans$ TO bonita;
GRANT select ON sys.dba_2pc_pending TO bonita;
GRANT execute ON sys.dbms_system TO bonita;
GRANT select ON sys.v$xatrans$ TO bonita;
GRANT execute ON sys.dbms_xa TO bonita;
GRANT FORCE ANY TRANSACTION TO bonita;
Which of these privileges are absolutely required in order for Bonita CE to work with the database ?
Regards,
Brad Pridgeon