3.6.2 Grant Privileges to Database User

The MicroTx Distributed Transactions coordinator and MicroTx Workflows create a stored procedure when the service starts. If the Oracle Database user does not have the permission to create and run stored procedures, the service does not start.

Perform this task only if you use Oracle Database as the data store. Grant the following privileges to the user who has access to the data store.

• To grant the privileges to create and run stored procedures, run the following command.

  Sample Command

  GRANT CREATE SESSION, CREATE TABLE, CREATE PROCEDURE, EXECUTE ANY PROCEDURE, CREATE VIEW, CREATE SEQUENCE, CREATE TYPE TO <data_store_user>;

  Where, <data_store_user> is the name of the user who has access to the data store.

• To grant tablespace which is required to create tables and procedures, run the following command. The following command grants unlimited tablespace privilege to the specified user. Modify the quota as per your requirement.

  Sample Command

  GRANT UNLIMITED TABLESPACE TO <data_store_user>;