Access rights for a Microsoft SQL Server database

Several permissions in the Microsoft SQL Server database are required by Kofax Transformation Modules on the fuzzy database source. These permissions are necessary in order to access tables, views, synonyms, and stored procedures.

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

  • CONNECT SQL

  • VIEW ANY DATABASE

  • VIEW ANY DEFINITION

    This permission is required by the sp_databases stored procedure that is used to list the databases that are accessible to the logged on user.

The following permission is also required by the "database role" or "user" for each relational object.

  • SELECT

    This is required to access views and tables.