12.Build a Team Role

Ana and Ben are analysts. Their roles ana and ben exist and have no privileges.

Create a group role analysts that cannot connect. Let it read orders and order_items.
Make ana and ben members of analysts. Give them no privileges of their own.
Can ana read orders now? Answer yes or no.
Ben moves to another team. Take his analyst access away, and keep Ana's.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT rolname, rolcanlogin FROM pg_roles WHERE rolname NOT LIKE 'pg\_%';

Ctrl↵runs the query · select text to run part of it

Objective 1 of 40/4 done