How can you ensure that only specific users can modify data in a PostgreSQL table while others can only view it?

hard📝 Application Q9 of 15

PostgreSQL - Roles and Security

AGrant ALL permissions to everyone

BGrant UPDATE permission only to specific users and SELECT to others

CRevoke all permissions from everyone

DUse VACUUM to clean the table

Step-by-Step Solution

Solution:

Step 1: Understand permission types
UPDATE allows modifying data; SELECT allows viewing only.
Step 2: Assign permissions based on user roles
Grant UPDATE to users who can modify; grant SELECT to others for read-only.
Final Answer:
Grant UPDATE permission only to specific users and SELECT to others -> Option B
Quick Check:
Control modify/view by granting UPDATE/SELECT accordingly [OK]

Quick Trick: Assign UPDATE to editors, SELECT to viewers [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free