[Solved] Identify the error in the following command:REVOKE ALL PRIVILEGES employees FROM bob; — Ans: The order of keywords is incorrect. | PostgreSQL

PostgreSQL - Roles and Security

Identify the error in the following command:
REVOKE ALL PRIVILEGES employees FROM bob;

AThe order of keywords is incorrect.

BThe user name should be before the table name.

CREVOKE cannot be used with ALL PRIVILEGES.

DThe command is correct.

Step-by-Step Solution

Solution:

Step 1: Check correct REVOKE syntax
The correct syntax is: REVOKE privileges ON object FROM user;
Step 2: Compare with given command
The command uses: REVOKE ALL PRIVILEGES employees FROM bob; missing ON keyword and wrong order.
Final Answer:
The order of keywords is incorrect. -> Option A
Quick Check:
REVOKE + privileges + ON + object + FROM + user [OK]

Quick Trick: REVOKE syntax requires ON before object [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in the following command: