Permission to view the tables within customers

issibra
New Contributor III

In databricks course V3 Unity catalog session I could not understand the answer of this question, can someone please enlighten me ?

A senior data engineer with workspace identity privileges has created the schema customers within a Unity Catalog namespace. They need to grant another data engineer on their team permission to view the tables within customers. The second data engineer has the username data.engineer@company.com

Which of the following commands can the senior data engineer use to accomplish this? Select one response. 

  • GRANT USAGE CREATE ON SCHEMA customers TO `data.engineer@company.com`
  • GRANT CREATE ON SCHEMA customers TO `data.engineer@company.com`; !!!!! 
  • GRANT ALL PRIVILEGES ON SCHEMA customers TO `data.engineer@company.com` 
  • GRANT USAGE ON SCHEMA `data.engineer@company.com` TO customers; 
  • GRANT USAGE ON SCHEMA customers TO `data.engineer@company.com`

The correct answer according to Databricks is the 2nd, do we need the Create permission just to give the permission to view a table ?

Thank you !