Database security permissions
Datacap users must have database permissions for DB2®, Microsoft SQL Server, or Oracle 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 Datacap users by using the
database-specific tool and following the instructions that are provided
with your database:
- For DB2, contains
multiple tools that you can use to configure DB2 databases. Select one of
the following tools and log on as administrator:
- Datacap Studio: the Datacap application development tool
- DB2 Command Line Processor CLP: a command line equivalent to Oracle SQLPlus
- DB2 Command Line Processor CLPlus: another command-line equivalents to Oracle SQLPlus
- 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 Datacap users
based on these tasks:
- Database administrators: create the database and its schema
- Datacap developers: initialize the data in the database
- Datacap Server: Run daily operations on the Administrator and Engine database tables
- Rulerunner and Fingerprint Services: Run daily operations on the Fingerprint database
- Datacap Web Client, Rulerunner, Datacap Desktop, 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. These users usually need read and in some cases write permissions to the Fingerprint database and any Lookup and Export databases that exist.
The following table lists the database permission and indicates which permissions are required for each of the 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 |
| Create and initialize columns | 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 records from a table | Required | Required | Not required |
| Create a trigger | Required | Not required | Not required |
| Create a view | Required | Not required | Not required |