[Solved] What is the main purpose of column-level permissions in PostgreSQL? — Ans: To restrict access to specific columns in a table | PostgreSQL

PostgreSQL - Roles and Security

What is the main purpose of column-level permissions in PostgreSQL?

ATo control database server startup options

BTo restrict access to specific columns in a table

CTo manage user passwords

DTo define table storage parameters

Step-by-Step Solution

Solution:

Step 1: Understand the role of permissions in PostgreSQL
Permissions control what users can do with database objects.
Step 2: Identify what column-level permissions specifically restrict
They limit access to certain columns within a table, not the whole table or server settings.
Final Answer:
To restrict access to specific columns in a table -> Option B
Quick Check:
Column-level permissions = restrict columns [OK]

Quick Trick: Column permissions limit columns, not whole tables or server [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the main purpose of column-level permissions in PostgreSQL?