QuestionQ82

Securing Data

How do privileges inherit in Unity Catalog across the metastore, catalog, schema, and table/view hierarchy levels?

  • A Privileges granted at a higher level (such as a catalog) automatically apply to all child objects (schemas and tables) unless overridden by more specific permissions at a lower level.
  • B Privileges are only inherited from the metastore level, and no inheritance occurs between catalogs, schemas, or tables.
  • C Privileges must be granted individually for each object, regardless of their position in the hierarchy, to ensure secure access control.
  • D Privileges granted at the schema level have no impact on tables or views in that schema unless directly applied to them.
Explanation

Unity Catalog privileges granted on a catalog inherit to its current and future schemas and the tables and views within them. Privileges granted on a schema likewise inherit to its current and future tables and views. Metastore-level privileges are scoped to metastore operations and do not inherit to child objects.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!