Solution:Step 1: Analyze granted permissionsAlice was granted SELECT (read) permission, Bob was granted INSERT permission.Step 2: Analyze revoked permissionsAlice's SELECT permission was revoked, so she no longer can read data.Final Answer:Alice cannot read data; Bob can insert data. -> Option AQui

[Solved] Given the commands:GRANT SELECT ON orders TO alice; GRANT INSERT ON orders TO bob; REVOKE SELECT ON orders FROM alice;Which of the following is true about user permissions on the orders table? | PostgreSQL

PostgreSQL - Roles and Security

Given the commands:

GRANT SELECT ON orders TO alice;
GRANT INSERT ON orders TO bob;
REVOKE SELECT ON orders FROM alice;

Which of the following is true about user permissions on the orders table?

AAlice cannot read data; Bob can insert data.

BAlice can read and insert data; Bob can only insert data.

CAlice can read data; Bob cannot insert data.

DBoth Alice and Bob have no permissions on the table.

Step-by-Step Solution

Solution:

Step 1: Analyze granted permissions
Alice was granted SELECT (read) permission, Bob was granted INSERT permission.
Step 2: Analyze revoked permissions
Alice's SELECT permission was revoked, so she no longer can read data.
Final Answer:
Alice cannot read data; Bob can insert data. -> Option A
Quick Check:
Revoked SELECT removes read access [OK]

Quick Trick: Revoking removes permission even if previously granted [OK]

Common Mistakes:

Assuming revoked permission still applies
Confusing INSERT with SELECT
Thinking REVOKE affects other users

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given the commands:

Step 1: Analyze granted permissions

Step 2: Analyze revoked permissions

Final Answer:

Quick Check:

Want More Practice?