DB2 Version 9.7 for Linux, UNIX, and Windows

authority_lvl - User authorization level monitor element

The highest authority level granted to an application.

Note: The authority_lvl monitor element is deprecated starting with DB2® database Version 9.5. Use the authority_bitmap monitor element instead. See authority_bitmap - User authorization level monitor element.
Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl Basic
Application appl_info Basic
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Connection event_conn -
Usage
The operations allowed by an application are granted either directly or indirectly.
The following defines from sql.h may be used to determine the authorizations granted explicitly to a user:
  • SQL_SYSADM
  • SQL_DBADM
  • SQL_CREATETAB
  • SQL_BINDADD
  • SQL_CONNECT
  • SQL_CREATE_EXT_RT
  • SQL_CREATE_NOT_FENC
  • SQL_SYSCTRL
  • SQL_SYSMAINT
The following defines from sql.h may be used to determine indirect authorizations inherited from group or public:
  • SQL_SYSADM_GRP
  • SQL_DBADM_GRP
  • SQL_CREATETAB_GRP
  • SQL_BINDADD_GRP
  • SQL_CONNECT_GRP
  • SQL_CREATE_EXT_RT_GRP
  • SQL_CREATE_NOT_FENC_GRP
  • SQL_SYSCTRL_GRP
  • SQL_SYSMAINT_GRP
Parent topic: Database system monitor elements
Related concepts:
Authorization, privileges, and object ownership