Access rights for an Oracle database

Several permissions in an Oracle database are required by Kofax TotalAgility in order to use it for the fuzzy database source. These permissions are necessary in order to access tables, views, and synonyms.

At a minimum, the Server login requires the following permissions.

• CONNECT SQL

• CREATE SESSION

• SELECT ANY TABLE or READ ANY TABLE

The following permissions are also required by the "role" or "user" for each relational object.

• SELECT

  This is required to access views, tables, and synonyms based on a view or table.

• EXECUTE

  This is required for the stored procedure and synonyms based on a stored procedure.

• In the case of a synonym, the user or database role also requires the corresponding SELECT/EXECUTE permissions for the underlying object referenced by the synonym.