$ su - oracle
$ sqlplus / as sysdba
SQL> @<ORACLE_HOME>/rdbms/admin/xaview.sql
SQL> grant SELECT on DBA_PENDING_TRANSACTIONS to public;
SQL> grant SELECT on v$xatrans$ to public;
SQL> grant SELECT on SYS.V$XATRANS$ to public;
SQL> grant EXECUTE on SYS.DBMS_SYSTEM to public;
SQL> quit
网友评论