You want to allow user dave to update only the phone column in the contacts table but not others. Which sequence of commands correctly achieves this?

hard📝 Application Q15 of 15

PostgreSQL - Roles and Security

You want to allow user dave to update only the phone column in the contacts table but not others. Which sequence of commands correctly achieves this?

AGRANT UPDATE(phone) ON contacts TO dave; REVOKE UPDATE ON contacts FROM dave;

BREVOKE UPDATE ON contacts FROM dave; GRANT UPDATE(phone) ON contacts TO dave;

CGRANT UPDATE ON contacts TO dave; REVOKE UPDATE(phone) ON contacts FROM dave;

DGRANT UPDATE(phone) ON contacts TO dave;

Step-by-Step Solution

Solution:

Step 1: Remove any existing full UPDATE permission
First revoke any broad UPDATE permission to avoid conflicts.
Step 2: Grant UPDATE permission only on the phone column
Then grant UPDATE on the specific column to limit access.
Final Answer:
REVOKE UPDATE ON contacts FROM dave; GRANT UPDATE(phone) ON contacts TO dave; -> Option B
Quick Check:
Revoke broad then grant column-level UPDATE [OK]

Quick Trick: Revoke broad permission before granting column-level update [OK]

Common Mistakes:

Granting column-level without revoking broad permission
Revoking column-level instead of broad permission
Assuming single GRANT is enough if broad permission exists

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

You want to allow user dave to update only the phone column in the contacts table but not others. Which sequence of commands correctly achieves this?

Step 1: Remove any existing full UPDATE permission

Step 2: Grant UPDATE permission only on the phone column

Final Answer:

Quick Check:

Want More Practice?