Permission to view the tables within customers

issibra — Tue, 23 May 2023 20:22:43 GMT

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 !

Re: Permission to view the tables within customers

issibra — Fri, 26 May 2023 21:01:05 GMT

The anwser for this question is mentionned here

https://community.databricks.com/s/question/0D58Y0000ACa06GSQR/is-there-any-hierarchy-within-schema-permissions

topic Re: Permission to view the tables within customers in Data Governance

Permission to view the tables within customers

Re: Permission to view the tables within customers