Access rights for an Oracle database

Several permissions in an Oracle database are required by Kofax Transformation Modules 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.

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