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

Posted by: Pdfprep Category: C2090-616 Tags: , ,

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 SYSCA
C . TABAUTH
D . The REVOKE statement succeeds with no effect
E . All privileges are granted to user MYUSER on MYTABLE

Answer: C

Leave a Reply

Your email address will not be published.