Try SQL · December Code

Try SQL

No account needed. Answer, see why, move on.

1 of 3 today

Viewseasy

Problem

In PostgreSQL, with default view settings, a table Employees has the columns emp_id, name, dept_id and salary. A DBA runs:

SQL

CREATE VIEW EmpDirectory AS SELECT emp_id, name, dept_id FROM Employees;

and grants the support team SELECT on EmpDirectory but no privileges on Employees. What does this achieve?

Choose one1The support team can read names and departments but not salaries, because the view returns only its listed columns and they have no access to Employees itself2The support team can read salaries through the view, because a view exposes every column of its base table3Nothing useful: the support team's queries on the view fail until they are also granted SELECT on Employees4The view stores a copy of the three columns, so the support team's queries no longer read Employees at all

choose an option

Nothing here is saved. Create a free account to keep your progress, take an assessment and get your readiness score.