A user needs to query the table `main.sales.orders` in Unity Catalog. An admin has granted `SELECT` on `main.sales.orders` to the user, but the query still fails with a permission error. What additional grants are most likely required?

Question

Accepted Answer

B. The user also needs `USE CATALOG` on `main` and `USE SCHEMA` on `main.sales`. In Unity Catalog, accessing a table requires privileges at every level of the hierarchy: `USE CATALOG` on the catalog, `USE SCHEMA` on the schema, and `SELECT` on the table (or inherited from a parent). Even with `SELECT` on the table, queries fail without the `USE CATALOG` and `USE SCHEMA` grants needed to navigate the namespace.

A user needs to query the table `main.sales.orders` in Unity Catalog. An admin has granted `SELECT` on `main.sales.orders` to the user, but the query still fails with a permission error. What additional grants are most likely required?

Related Questions

Discussion

A user needs to query the table main.sales.orders in Unity Catalog. An admin has granted SELECT on main.sales.orders to the user, but the query still fails with a permission error. What additional grants are most likely required?

Related Questions

Discussion

A user needs to query the table `main.sales.orders` in Unity Catalog. An admin has granted `SELECT` on `main.sales.orders` to the user, but the query still fails with a permission error. What additional grants are most likely required?