Anonymous
Not applicable

I think the simplest way to achieve what you're looking for is to use Unity Catalog. https://www.databricks.com/product/unity-catalog