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 !