Granting privileges through administrative authorities
A Db2 administrative authority is generally vested with a predefined group of privileges. If you need to grant a user a specific set of privileges that are already included in an authority, you can grant the user the authority, instead of individual privileges.
About this task
For each administrative authority that you grant, Db2 adds a row in the system authorization table and sets the corresponding column to Y or G. For example, if you grant a user the SYSOPR authority on a database, Db2 adds a row in the SYSIBM.SYSUSERAUTH table and sets the SYSOPRAUTH column to Y or G. In addition, Db2 sets the columns for the DISPLAY, RECOVER, STOPALL and TRACE privileges to Y or G because these privileges are included in the SYSOPR authority.
If you include other privileges in the same GRANT statement for the SYSOPR authority, Db2 adds a corresponding row for each of the additional privileges in the SYSIBM.SYSUSERAUTH table. For example, if you include SYSOPR and MONITOR2 on the same GRANT statement, Db2 adds two rows in the SYSIBM.SYSUSERAUTH table, one for the SYSOPR authority and the other for the MONITOR2 privilege.