A data engineer runs the following command:
GRANT SELECT ON CATALOG main TO `analyst_team`;A new table called
main.reporting.revenue is created one week later. Which of the following statements CORRECTLY describes analyst_team's access to this new table?
Answer & explanation
Correct answer: D
WHY D is correct: Unity Catalog uses a privilege inheritance model where privileges granted at a higher level in the object hierarchy automatically apply to all current AND future objects beneath it. The documentation explicitly states: 'Since privileges are inherited, you can grant a user the SELECT privilege on a catalog or schema, which automatically grants the user SELECT privilege on all current and future tables, and views in the catalog or schema.' Furthermore, granting SELECT at the catalog level implicitly covers the necessity to traverse the hierarchy — the GRANT at the catalog level encompasses the USE CATALOG privilege on that same catalog. Similarly, USE SCHEMA is also covered by the catalog-level grant because all descendant privileges inherit downward. The analyst team can therefore immediately query main.reporting.revenue without any further explicit grants.
WHY NOT A: This is incorrect. Privilege inheritance means existing catalog-level grants propagate to future objects automatically. There is no requirement to re-grant privileges each time a new object is created when the grant was made at the catalog level.
WHY NOT C: With a catalog-level SELECT grant in place, there is no need for the table owner to grant SELECT on individual tables. Inheritance eliminates the need for object-by-object grants for users who already have the privilege at a higher level.
WHY NOT B: When SELECT is granted at the catalog level, USE CATALOG and USE SCHEMA are implicitly satisfied as part of the catalog-level inheritance. They do not need to be granted separately; the catalog-level grant covers the full navigation chain needed to access objects within that catalog.