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 our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.