Support SELECT of a view without accessing of the base tables (Data products)

This looks a lot like the response I gave at the bottom of Restricting Catalog Access in Starburst Console - #3 by NIHAL which basically says that Starburst Enterprise data products as called out at Manage data products — Starburst Enterprise are leveraging the DEFINER, not INVOKER, as compared in CREATE VIEW — Starburst Enterprise.

To bring that point home a bit, Data products overview — Starburst Enterprise calls out some details about security and impersonation. Hope that all helps.

2 Likes