[Solved] Which SQL command is used to remove column-level SELECT permission from a user in PostgreSQL? — Ans: REVOKE SELECT (column_name) ON table_name FROM user_name; | PostgreSQL

PostgreSQL - Roles and Security

Which SQL command is used to remove column-level SELECT permission from a user in PostgreSQL?

AREMOVE SELECT ON column_name FROM user_name;

BREVOKE SELECT (column_name) ON table_name FROM user_name;

CDENY SELECT ON table_name TO user_name;

DDROP PERMISSION SELECT ON table_name FOR user_name;

Step-by-Step Solution

Solution:

Step 1: Recall the syntax for revoking permissions in PostgreSQL
PostgreSQL uses REVOKE to remove permissions.
Step 2: Identify correct syntax for column-level revoke
REVOKE SELECT (column_name) ON table_name FROM user_name; is the correct form.
Final Answer:
REVOKE SELECT (column_name) ON table_name FROM user_name; -> Option B
Quick Check:
Revoke column permission = REVOKE SELECT (col) ON table [OK]

Quick Trick: Use REVOKE with column list in parentheses for column permissions [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which SQL command is used to remove column-level SELECT permission from a user in PostgreSQL?