Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Granting Permissions on Stored Procedures in EAI Database Steps

## Status

If you are... | This task is...
Installing a new iProcess Engine Version 11.9.0 | Possibly required
Upgrading from an iProcess Engine Version 11.0 or later | Possibly required

## Database

Oracle, SQL Server

## Description

The EAI steps are used to communicate with database stored procedures. You must grant execute permission to `swuser` on all custom stored procedures used by EAI Database steps if you are using TIBCO iProcess Engine version 11.4.0 or later.

If you are using TIBCO iProcess Engine earlier version than 11.4.0, the foreground processes connect to the database using the Oracle foreground user (`swuser`), whereas the Oracle background user (`swpro`), is used for the background processes. For example, the `WIS` processes connect to the Oracle database as the `swuser` user whereas the `BG` processes connected to the Oracle database as the `swpro` user.

If you are using TIBCO iProcess Engine version 11.4.0 or later, all the processes, regardless of whether they are background or foreground processes, connect to the Oracle database as the Oracle foreground user, which by default is the `swuser` user.

## Procedure

See related database documentation on how to grant execute permission.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.