[Solved] Which PostgreSQL command is used to allow a user to add new rows to a specific table? — Ans: GRANT INSERT ON table_name TO user_name; | PostgreSQL

PostgreSQL - Roles and Security

Which PostgreSQL command is used to allow a user to add new rows to a specific table?

AGRANT SELECT ON table_name TO user_name;

BGRANT UPDATE ON table_name TO user_name;

CREVOKE DELETE ON table_name FROM user_name;

DGRANT INSERT ON table_name TO user_name;

Step-by-Step Solution

Solution:

Step 1: Understand the permission types
INSERT permission allows adding new rows to a table, SELECT allows reading data, DELETE allows removing rows, and UPDATE allows modifying existing rows.
Step 2: Identify the correct command for adding rows
The command to allow adding rows is GRANT INSERT ON table_name TO user_name; which grants INSERT permission on the table.
Final Answer:
GRANT INSERT ON table_name TO user_name; -> Option D
Quick Check:
INSERT permission = GRANT INSERT ON table_name TO user_name; [OK]

Quick Trick: INSERT permission lets users add rows to tables [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 allow a user to add new rows to a specific table?