Why Does JON Need Execute On SYS.DBMS_SYSTEM?
Issue
- I'm trying to install JON and I'm following the instructions at http://docs.redhat.com/docs/en-US/JBoss_Operations_Network/2.4/html/Installation_Guide/JON_Server_Installation.html
-
Step 5 of Section 2.1.2.2 calls for the following permissions:
GRANT SELECT ON sys.dba_pending_transactions TO rhqadmin; GRANT SELECT ON sys.pending_trans$ TO rhqadmin; GRANT SELECT ON sys.dba_2pc_pending TO rhqadmin; GRANT EXECUTE ON sys.dbms_system TO rhqadmin;
-
Our DBA would like to know why JON needs Execute on SYS.DBMS_SYSTEM?
Environment
- JBoss Operations Network (JON) 2.4
- Oracle Relational Database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.