IBM Datacap, Version 8.1

Database security permissions

IBM® Datacap Taskmaster Capture users must have Microsoft SQL Server or Oracle database permissions to create the database and its schema, initialize the data in the database, and run daily operations on the database.

You set up database permissions for Taskmaster users by using the database-specific tool and following the instructions that are provided with your database:

For SQL Server, start SQL Server Management Studio or SQL Server Enterprise Manager and log on to the server as the administrator
For Oracle, start the SQLPlus tool and log on to the SYS account as SYSDBA

Assign the appropriate permissions from the following table to the Taskmaster users based on these tasks:

Database administrators: create the database and its schema
Taskmaster developers: initialize the data in the database
Taskmaster Server: Run daily operations on the Administrator and Engine database tables
Rulerunner and Fingerprint Services: Run daily operations on the Fingerprint database
Taskmaster Web, Rulerunner, Taskmaster DotScan, Taskmaster DotEdit, and other thick clients: Run daily operations on queries that are run by actions. The permissions are application-specific and apply only to those queries that are run by actions.

The following table lists the database permission and indicates which permissions are required for each of the database tasks.

Table 1. Required database permissions for SQL Server and Oracle database tasks
Database permission	Create database and schema	Initialize data in the database	Run daily operations
Create an index	Required	Not required	Not required
Drop an index	Required	Not required	Not required
Create a sequence	Required	Required	Not required
Drop a sequence	Required	Required	Not required
Select a sequence	Required	Required	Required
Create a table	Required	Not required	Not required
Drop a table	Required	Not required	Not required
Insert a table	Required	Required	Required
Select a table	Required	Required	Required
Update a table	Required	Required	Required
Delete a table	Required	Required	Not required
Create a trigger	Required	Not required	Not required
Create a view	Required	Not required	Not required

Feedback