PrepAway - Latest Free Exam Questions & Answers

which of the following is the best way to remove all privileges user USER1 holds?

User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1,
which of the following is the best way to remove all privileges user USER1 holds?

PrepAway - Latest Free Exam Questions & Answers

A.
REVOKE CONTROL ON table1 FROM user1

B.
REVOKE ALL PRIVILEGES ON table1 FROM user1

C.
REVOKE CONTROL ON table1 FROM user1;
REVOKE ALL PRIVILEGES ON table1 FROM user1;

D.
REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1

One Comment on “which of the following is the best way to remove all privileges user USER1 holds?


Leave a Reply