PostgreSQL - Roles and Security
What does the
GRANT SELECT ON table_name TO user_name; command do in PostgreSQL?What does the GRANT SELECT ON table_name TO user_name; command do in PostgreSQL?
easy📝 Conceptual Q11 of 15
Step-by-Step Solution
Solution:
Step 1: Understand the GRANT command
The GRANT command is used to give specific permissions to users on database objects like tables.Step 2: Identify the permission type SELECT
SELECT permission allows reading data from the table but not modifying it.Final Answer:
Allows the user to read data from the specified table. -> Option DQuick Check:
GRANT SELECT = read permission [OK]
Quick Trick: GRANT SELECT means read access only [OK]
Common Mistakes:
- Confusing SELECT with DELETE permission
- Thinking GRANT creates tables
- Mixing GRANT with REVOKE commands
Master "Roles and Security" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes