You must log into the database as Pat before proceeding with this page.
The CEO of J.K. Avro Superstore wants to separate duties between database administration and security administration. Hence he would like to revoke SECADM authorities from the database creator.
Starting from DB2 9.7, only SECADM has authority to revoke SECADM and DBADM authorities.
Pat who holds SECADM authority revokes SECADM authority from the database creator.
On the right pane, click Edit Query. Replace ~~~~DATABASE_CREATOR~~~~ with the username used to create the SECURITY database.
The REVOKE command in the right pane show that Pat revokes SECADM authority from the database creator who now holds only SYSADM, DBADM, DATAACCESS, and ACCESSCTRL authorities.