Security Model. This package is created under SYS.Operations provided by this package are performed under the current calling user, not under the package owner SYS.Any DBMS_XA subprogram called from an anonymous PL/SQL block is executed using the privileges of the current user. Any DBMS_XA subprogram called from a stored procedure is executed using the privileges of the owner of the stored …
Re: How to test grant on execute dbms_xa? Paulzip Dec 23, 2015 12:11 PM ( in response to Ranieri ) Accessing anything in the package spec will check permissions.
Certain privileges are necessary for a user to execute particular XA tasks: 1. To execute xa_recover, the user must have select privileges in the dba_pending_transactions view. 2. To manipulate XA transactions created by other users, the force any transaction privilege is required. In the next example …
GRANT EXECUTE ON sys.dbms_xa TO user; The above assumes that the user is the user defined to connect from WildFly to Oracle. It also assumes that either Oracle 10g.
GRANT EXECUTE ON sys. dbms _xa TO user GRANT SELECT ON sys.dba_2pc_pending TO user where user is the name of the BPM database user (as defined by the Username field in the ActiveMatrix BPM: Runtime Database Configuration screen of the Create TIBCO ActiveMatrix BPM Server Wizard – for example, bpmuser).
In second option kindly grant role SELECT ANY DICTIONARY to rdsadmin and after that execute following SQL statement. As rdsadmin grant select on sys.dba_objects to my_role; – …
