If the command GRANT ALL PRIVILEGES ON TABLE sales TO eve; is executed, which of the following is true about user eve?

medium📝 query result Q5 of 15

PostgreSQL - Roles and Security

If the command GRANT ALL PRIVILEGES ON TABLE sales TO eve; is executed, which of the following is true about user eve?

Aeve has no permissions on sales

Beve has all permissions including SELECT, INSERT, UPDATE, DELETE on sales

Ceve only has SELECT permission on sales

Deve can only read data but cannot modify sales

Step-by-Step Solution

Solution:

Step 1: Understand ALL PRIVILEGES
ALL PRIVILEGES means all standard permissions like SELECT, INSERT, UPDATE, DELETE.
Step 2: Apply to user eve
eve receives full control on the sales table.
Final Answer:
eve has all permissions including SELECT, INSERT, UPDATE, DELETE on sales -> Option B
Quick Check:
GRANT ALL PRIVILEGES = full permissions [OK]

Quick Trick: GRANT ALL PRIVILEGES gives full access [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free