Why does JBoss need execute on Oracle DBMS_SYSTEM
Issue
We are seeing the following errors in the Oracle backend;
Error Message: Backends|Oracle DB|SQL|Dynamic|Query|BEGIN SYS.DBMS_SYSTEM.DIST_TXN_SYNC (?) ; END ;: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Appears to resolve this we need to grant permissions to the schema owner and the DBA is pushing back against why this permission is needed against this Oracle SYS package.
Environment
JBoss Enterprise Application Platform 5
JBoss Enterprise Application Platform 6
Oracle Database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
