[Solved] What does the GRANT command do in PostgreSQL? — Ans: It gives specific permissions to a user or role. | PostgreSQL

PostgreSQL - Roles and Security

What does the GRANT command do in PostgreSQL?

AIt gives specific permissions to a user or role.

BIt deletes a user from the database.

CIt creates a new database.

DIt backs up the database.

Step-by-Step Solution

Solution:

Step 1: Understand the purpose of GRANT
The GRANT command is used to give permissions like SELECT, INSERT, or UPDATE to users or roles.
Step 2: Compare with other options
Deleting users, creating databases, or backing up are done by other commands, not GRANT.
Final Answer:
It gives specific permissions to a user or role. -> Option A
Quick Check:
GRANT = give permissions [OK]

Quick Trick: GRANT means give rights; REVOKE means take away [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does the GRANT command do in PostgreSQL?