Unable to update view comment via SQL/API unless owner, but column comments work (Unity Catalog)

shadman140
New Contributor

I’m working with Databricks Unity Catalog and observing an inconsistent permission behavior for views.

Scenario

  • A view exists that was created by another user

  • I have sufficient privileges on the catalog/schema/view (SELECT, MODIFY, ALL PRIVILEGES)

  • I can:

    • Query the view

    • Add column comments for view successfully using SQL editor in databricks UI and /statements api end point with COMMENT ON COLUMN query

    • Update the view comment via Databricks UI

  • But I cannot update the view-level comment via SQL editor in databricks UI or API

Question

  • Why Views is bound by this owner condition while table works with MODIFY permission only?
  • While documentation says, "Comment on column" will only work for owners but I am able to use it even when I don't own the view?