Revoking privileges granted by other IDs

An ID with the SYSADM or SYSCTRL authority can revoke privileges that are granted by other IDs.

To revoke privileges granted by other IDs, choose one of the following approaches:

• Issue a REVOKE statement and include BY ALL in that statement.
  This statement will revoke privileges granted by all other IDs.
  The following example revokes the CREATETAB privileges that are granted to PGMR01 on database DB1 by all IDs:

  REVOKE CREATETAB ON DATABASE DB1 FROM PGMR01 BY ALL;

• Issue a REVOKE statement and include the specific ID in that statement.
  This statement will revoke privileges that were granted by a specific ID and leave intact the same privileges if they were granted by any other ID.
  The following example revokes privileges that are granted by DBUTIL1 and leaves intact the same privileges if they were granted by any other ID:

  REVOKE CREATETAB, CREATETS ON DATABASE DB1 FROM PGMR01 BY DBUTIL1;