Oracle required sys privileges

1
0
-1

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

1 answer

1
0
-1

a

Notifications