Scenario
- Under Hive Metastore four diff schema exist S1,S2,S3 and S4
- 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
- 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
- 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 ??