Exam C2090-616 topic 1 question 5 discussion

answer A SQL0556N An attempt to revoke a privilege, security label, exemption, or role from authorization-ID was denied because authorization-ID does not hold this privilege, security label, exemption, or role. Explanation The privilege, security label, exemption, or role cannot be revoked because authorization-ID does not hold the privilege, security label, exemption, or role. The statement cannot be processed. User response Change the REVOKE statement to conform to the REVOKE rules and resubmit the statement. Ensure that when a REVOKE statement lists several privileges, security labels, exemptions, or roles to be revoked and a list of authorization IDs that each authorization ID possesses at least one of the specified privileges, security labels, exemptions, or roles. sqlcode: -556 sqlstate: 42504 sqlcode: -556 --> negative code means error for DB2

A is GOOD -> A. An error is returned

The good answer is "A. An error is returned " You will get the following error : SQL0556N An attempt to revoke a privilege, security label, exemption, or oral from "MYUSER" was denied because "MYUSER" dos not hold this privilege, security label, exemption, or role.