What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
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.
A is GOOD -> A. An error is returned
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