โ03-07-2022 12:24 AM
Hi Community,
Let's take a scenario where the data from s3 is read to create delta table and then stored on dbfs, and then to query these delta table we used mysql endpoint from where all the delta tables are visible, but we need to control which all delta tables can be visible through that endpoint.
โ03-07-2022 02:31 AM
GRANT privilege_types ON securable_object TO principal
privilege_types
{ ALL PRIVILEGES |
privilege_type [, ...] }
REVOKE privilege_types ON securable_object FROM principal
privilege_types
{ ALL PRIVILEGES |
privilege_type [, ...] }
principal need to be user which connect through sql endpoint (from BI tool for example)
โ03-07-2022 01:01 AM
Best you browse through the docs.
Interesting to know is that with Unity Catalog, new functionalities will be added. Mind that it is not yet GA.
โ03-07-2022 01:08 AM
@Werner Stinckensโ
Thanks for your kind response, Surely I will go through the above said suggestion and will contact team to make it available for testing and will let you know if it can fulfill above said usecase
โ03-07-2022 02:31 AM
GRANT privilege_types ON securable_object TO principal
privilege_types
{ ALL PRIVILEGES |
privilege_type [, ...] }
REVOKE privilege_types ON securable_object FROM principal
privilege_types
{ ALL PRIVILEGES |
privilege_type [, ...] }
principal need to be user which connect through sql endpoint (from BI tool for example)
โ03-11-2022 12:36 AM
Hi @Athlestan Jainโ , Let us know if you were able to achieve this using @Hubert Dudekโ solution.
You can also restrict the endpoint by using Access control along with a combination of the proposed solution.
โ04-22-2022 07:04 AM
Hey @Athlestan Jainโ
Just checking in. Do you think you were able to find a solution to your problem from the above answers? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?
Thank you!
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