PostgreSQL - Roles and Security
A user has USAGE and CREATE privileges on schema 'finance'. They create a table but cannot insert data into it. What is the likely cause?
A user has USAGE and CREATE privileges on schema 'finance'. They create a table but cannot insert data into it. What is the likely cause?
hard📝 Application Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Understand privileges for data insertion
INSERT privilege on the table is required to add data.Step 2: Analyze the user's privileges
USAGE and CREATE allow schema access and table creation but not data modification.Final Answer:
They lack INSERT privilege on the table -> Option AQuick Check:
INSERT privilege needed to add data to tables [OK]
Quick Trick: Table INSERT privilege is separate from schema privileges [OK]
Common Mistakes:
- Assuming CREATE includes data modification rights
- Confusing database USAGE with schema USAGE
- Thinking schema ownership is required for inserts
Master "Roles and Security" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes