Posted by: Pdfprep
Post Date: November 6, 2020
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