Name all the 12 different authorities in Db2

1.	Name all the 12 different authorities in Db2
Answer» 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

Discussion