Unless specifically stated for a given task, the user does not require database administrator privileges.
Administrator privileges
The
following list includes some of the basic privileges that should be
granted to the 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.
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.