When using distributed transactions (JTA) with Oracle, the
connected Oracle user requires SELECT privilege on the
DBA_PENDING_TRANSACTIONS system view.
Use a tool such as Oracle's SQL*Plus to issue the following query. This
query verifies whether the connected Oracle user has SELECT privilege on
the system view DBA_PENDING_TRANSACTIONS.
For example,
sqlplus ejb/ejb
SQL> SELECT * FROM dba_pending_transactions ;
no rows selected
If you get the following Oracle error ORA-00942, the user does not have
SELECT privilege.
sqlplus ejb/ejb
SQL> SELECT * FROM dba_pending_transactions ;
select * from dba_pending_transactions
*
ERROR at line 1:
ORA-00942: table or view does not exist
To grant SELECT privilege on the DBA_PENDING_TRANSACTIONS system view,
use a tool such as Oracle's SQL*Plus to log on to Oracle as SYS
user, then issue the following command:
sqlplus sys/change_on_install
SQL> GRANT SELECT ON dba_pending_transactions to EJB ;
Grant succeeded.
Note: The default password for SYS user is
CHANGE_ON_INSTALL.
|