Db2® user privileges

Unless specifically stated for a given task, the Sterling Order Management System Software user does not require database administrator privileges.

Administrator privileges

The following list includes some of the basic privileges that should be granted to the Sterling Order Management System Software administrative user who creates or modifies the Db2 database:
  • BINDADD
  • CONNECT
  • CREATETAB
  • CREATE_EXTERNAL_ROUTINE
  • CREATE_NOT_FENCED_ROUTINE
  • DATAACCESS
  • LOAD
  • OS User Groups: db2iadm

Application user privileges

The following list contains basic privileges that should be granted to users who will only run the application.
  • CONNECT
  • DATAACCESS
Note: It will be necessary to grant USAGE privileges to database objects such as sequences to the application user, if the Application User was not used during the product installation. You can find these sequences by querying the catalog view SYSCAT.SEQUENCES for the Application Installation User.