Authorities and privileges for database tasks


Task Authorities and privileges
To add a database to your system You must have SYSADM or SYSCTRL authority.
To configure a database You must have SYSADM, SYSCTRL, or SYSMAINT authority.
To add or change the information that describes a database You must have SYSADM or SYSCTRL authority.
To grant DBADM authority

To grant other authorities

SYSADM authority is required.

either DBADM or SYSADM is required.

To back up a database or a database partition You must have SYSADM, SYSCTRL, or SYSMAINT authority.
Before you create a backup plan:
  • You must have SYSADM, SYSCTRL, or SYSMAINT authority.
  • If you change a database configuration file to enable roll-forward recovery (using either LOGRETAIN or USEREXIT), you must take an offline backup of the database before it is usable.


Anyone with SYSADM or DBADM authority can grant you with the authority to access a specific system, instance, or database.
Before you can add a database to your system You must have the following DB2 authorities:
  • SYSADM
  • SYSCTRL
To create a database from a backup image You must have SYSADM, SYSCTRL, or SYSMAINT authority.
Before you can configure your database You must have the following DB2 authorities:
  • SYSADM
  • SYSCTRL

The server must have a minimum of 16 MB of RAM.

The suggested values are only relevant for one database per instance. If you want to use this wizard on more than one database, each database should belong to a separate instance.

To restore a database or a database partition You must have SYSADM, SYSCTRL, or SYSMAINT authority.
Before you can restore a database you must have:
  • SYSADM, SYSCTRL, or SYSMAINT, authority.
  • An exclusive connection: that is, no applications can be running against the database when the task is started. Once it starts, it prevents other applicatio from accessing the database until the restore is completed.

To restore to a new database You must have SYSADM or SYSCTRL authority.
To perform roll-forward recovery You must have SYSADM, SYSCTRL, or SYSMAINT authority.
To restart a database You must have sysadm authority.