cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Restrict User to see schema using "all purpose compute"

robbinbajaj
New Contributor

Scenario 

  • Under Hive Metastore four diff schema exist S1,S2,S3 and S4 
  1. User1 want access to schema S1 but not allowed to see other 3 Schema which can be done using grant permission simple and easy case 
  2. Same User1 has access to workspace. Now same user using workspace to create pyspark using any "all purpose compute" can see all 4 schema. which is not visible if use SQL End point 
  3. Table Access Control already enabled under security setting. 

Problem Statement :

Using SQL end point restrict schema level access is possible but can it possible to restrict using "All purpose compute" cluster ??

1 REPLY 1

gchandra
Databricks Employee
Databricks Employee

The best option for Governance is to upgrade to Unity Catalog. 

This is alternate, not the best.

https://docs.databricks.com/en/data-governance/table-acls/object-privileges.html#requirements



~

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group