6.12.4 Privileges

Set the privileges required to run the MicroTx PL/SQL library.

The following privileges are required to run the MicroTx PL/SQL library:

• CREATE SESSION
• CREATE TABLE
• CREATE PROCEDURE
• CREATE SEQUENCE
• CREATE TYPE

To perform XA operations using the MicroTx PL/SQL library, you must set the following privileges.

• GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO user;

• GRANT FORCE ANY TRANSACTION TO user;

For more information, see DBMS_XA Data Structures in PL/SQL Packages and Types Reference.

The MicroTx PL/SQL library is available only in the schema where you ran the tmmxa.sql file. If you want to access the library components cross schema, then it is the database administrator's responsibility to provide the required permissions to run the library functions.

Run all library functions, procedures, types, packages with invoker rights or the privileges of the current user. Set AUTHID to indicate that you want to use invoker's rights. For example:

CREATE PROCEDURE proc1 AUTHID CURRENT_USER ...

For more information on AUTHID and privileges, see Oracle Database PL/SQL Language Reference.