08.Build the Phone Book

The phone book app connects as directory. HR connects as hr. Both roles exist and have no privileges.

Let directory read the id, name, title and department_id of employees, and no other column.
Become directory and run SELECT * FROM employees;. Which two words of the error say why it failed?
Still as directory, list the name and title of every employee.
Let hr change the title of employees, and no other column. You must be yourself again to grant it.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT * FROM employees;

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

Objective 1 of 40/4 done

Let directory read four columns
id, name, title and department_id of employees. Not salary, manager_id or hired_on.