06.Take Privileges Away

An intern got too many privileges, and someone shared a table with everyone.

How many privileges does intern have on products?
Make intern read-only on products: it keeps SELECT and loses the rest.
intern has no grant of its own on employees. Can it read employees? Answer yes or no. Check with SET ROLE and come back with RESET ROLE.
Make sure no role except the owner can read employees.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT grantee, table_name, privilege_type
FROM information_schema.table_privileges
WHERE grantee = 'intern';

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

Objective 1 of 40/4 done