IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 8

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser

Answer options

• A. An error is returned
• B. An entry is mane in SYSCAT.TABAUTH
• C. The REVOKE statement succeeds with no effect
• D. All privileges are granted to user MYUSER on MYTABLE C

Correct answer:

Explanation

The correct answer is C because when you revoke a privilege that does not exist, the statement completes successfully without making any changes. Options A, B, and D are incorrect because no error is generated, no entry is made in SYSCAT.TABAUTH for non-existent privileges, and no privileges can be granted since MYUSER holds none.