[Solved] Which of the following is a key advantage of using views for security in PostgreSQL? — Ans: Views can restrict access to specific columns or rows without changing the base... | PostgreSQL

PostgreSQL - Views and Materialized Views

Which of the following is a key advantage of using views for security in PostgreSQL?

AViews encrypt the data automatically

BViews prevent all users from querying the database

CViews can restrict access to specific columns or rows without changing the base table

DViews create backups of the data

Step-by-Step Solution

Solution:

Step 1: Understand how views control data visibility
Views can show only selected columns or rows, hiding sensitive data from users.
Step 2: Recognize the security benefit
This selective visibility allows controlling what users can see without altering the original tables.
Final Answer:
Views can restrict access to specific columns or rows without changing the base table -> Option C
Quick Check:
Views restrict data access = B [OK]

Quick Trick: Use views to limit data exposure without changing tables [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is a key advantage of using views for security in PostgreSQL?