Practice mode DBMS and SQL

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.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.