PdfPrep.com

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

Answer: C

Exit mobile version