User ali was earlier given SELECT on table Emp. Which statement correctly withdraws that privilege?
Correct answer C. REVOKE SELECT ON Emp FROM ali;
Explanation
Privileges are given with GRANT ... ON object TO user and withdrawn with REVOKE ... ON object FROM user. These are the DCL (Data Control Language) commands. The second option uses TO, which belongs to GRANT, so it is a syntax error. GRANT NO and DROP PRIVILEGE do not exist in standard SQL. A privilege that ali passed on using WITH GRANT OPTION may also need CASCADE to remove.
Answer checked How we write and check questions
Discussion