Expect to come across this popular question in DB2 interview questions and answers. SYSADM: for managing the instance as a whole SYSCTRL: for administering a database manager instance SYSMAINT: for maintaining databases within an instance SYSMON: for monitoring the instance and its databases SECADM: for managing security within a database DBADM: for administering a database ACCESSCTRL: for granting and revoking authorities and privileges (except for SECADM, DBADM, ACCESSCTRL, and DATAACCESS authority SECADM authority is required to grant and revoke these authorities) DATAACCESS: for accessing data SQLADM: for monitoring and tuning SQL queries WLMADM: for managing workloads EXPLAIN: for doing explain query plans (EXPLAIN authority does not  give access to the data itself LOAD: Users with LOAD authority are allowed to perform the following tasks: Quiesce or query the state of a tablespace Perform bulk-load operations by using the LOAD command Collect catalogue statistics by using the RUNSTATS command