[Solved] What is wrong with this command?REVOKE FROM user3 SELECT ON customers; — Ans: Incorrect order of keywords in REVOKE statement | PostgreSQL

PostgreSQL - Roles and Security

What is wrong with this command?

REVOKE FROM user3 SELECT ON customers;

AIncorrect order of keywords in REVOKE statement

BUser name should be quoted

CREVOKE cannot remove SELECT permission

DTable name is invalid

Step-by-Step Solution

Solution:

Step 1: Recall correct REVOKE syntax
The correct order is REVOKE permission ON table FROM user;
Step 2: Compare with given command
The command has FROM user before permission and table, which is incorrect syntax.
Final Answer:
Incorrect order of keywords in REVOKE statement -> Option A
Quick Check:
REVOKE syntax = REVOKE permission ON table FROM user [OK]

Quick Trick: REVOKE syntax order: permission ON table FROM user [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with this command?