- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2024 07:04 AM
I am attempting to use the Databricks API to get a list of the schemas and tables a group or user has permissions for. Is this possible? Is there another method I should be using instead?
I see the Unity Catalog > Grants > Get permissions endpoint can list the principals that have permissions for a schema or table, but this is the inverse of what I need.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2024 12:16 PM
To make sure I am in the correct path, you want to provide a group id for example or an user id and that the API retrieves all the objects that this user has access to? If this is the case unfortunately as of now there is no API available to collect this information as the permissions are handled by object and not by the principal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 01:06 PM
Thanks, @Walter_C. In my case, I was able to get the data I needed by using the Databricks SQL Driver for Node.js , querying the information_schema.table_privileges table.
