PrepAway - Latest Free Exam Questions & Answers

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?

REVOKE SELECT ON TABLE mytable FROM USER myuser

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


Leave a Reply