8.5 Review Role Grantees with WITH ADMIN OPTION

Information

Using the WITH ADMIN OPTION clause of the GRANT (Role) SQL statement, the security administrator can delegate the management and control of membership in a role to someone else.

Solution

1. Attach to DB2 Instance-
db2 => attach to $DB2INSTANCE
2. Connect to DB2 database-
db2 => connect to $DBNAME
3. Perform the following query-
db2=> revoke admin option for role <role name> from user <user name>

See Also

https://workbench.cisecurity.org/files/162