Question

A data engineering team of 12 people needs SELECT access to all current and future tables in the schema `sales.transactions`. New engineers join the team every few months. The lead wants to minimize ongoing administrative overhead when granting access. What is the best approach in Unity Catalog?

Accepted Answer

Create a group, add all engineers to it, and grant SELECT on the schema to the group

Answer

Grant SELECT on the schema individually to each of the 12 engineers by their user email

Answer

Grant SELECT on each existing table to a group, repeating the grant whenever a new table is created

Answer

Grant the MANAGE privilege on the schema to each engineer so they can read all tables