Grant Privilege to Run Stored Procedures

3.7.1 Grant Privilege to Run Stored Procedures

The MicroTx coordinator creates 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 privilege to create and run stored procedures, run the following command.
Sample Command
```
GRANT CREATE SESSION, CREATE TABLE, CREATE PROCEDURE, EXECUTE ANY PROCEDURE 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>;
```

Parent topic: Set Up Oracle Database as Data Store