[Solved] Which PostgreSQL command is used to give a user permission to SELECT data from a table? — Ans: GRANT SELECT ON table_name TO user_name; | PostgreSQL

PostgreSQL - Roles and Security

Which PostgreSQL command is used to give a user permission to SELECT data from a table?

AALLOW SELECT ON table_name TO user_name;

BGRANT SELECT ON table_name TO user_name;

CPERMIT SELECT FROM table_name TO user_name;

DACCESS SELECT ON table_name TO user_name;

Step-by-Step Solution

Solution:

Step 1: Recall PostgreSQL syntax for permissions
PostgreSQL uses the GRANT command to give permissions to users.
Step 2: Match the correct syntax
The correct syntax is "GRANT SELECT ON table_name TO user_name;", which is the only valid command among the options.
Final Answer:
GRANT SELECT ON table_name TO user_name; -> Option B
Quick Check:
GRANT = give permission [OK]

Quick Trick: GRANT is the keyword to give permissions in PostgreSQL [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which PostgreSQL command is used to give a user permission to SELECT data from a table?