- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 12:20 AM
I have all the necessary permissions like USE CATALOG on Catalog, USE SCHEMA on Schema and SELECT,TABLE on Table. But still when I try to access the table from catalog I get the error : Insufficient privileges: User does not have USE CATALOG on Catalog <Catalog_Name>. SQLSTATE: 42501. Also I am able to access the Table when I am using a SQL serverless compute but want to perform some ML functions using the 15.4 ML LTS compute.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 04:03 AM
Could you please specify which cluster access modes you are using?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 04:31 AM
Hi @Aman_Pundhir ,
Could you please confirm if you are using a cluster with dedicated access mode and whether you are the owner of the table/streaming table you are trying to access?
Also, please review: https://docs.databricks.com/aws/en/dlt/dbsql/streaming#requirements
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2025 10:11 PM
Thanks for your concerns. I was able to find the problem. So the problem was the cluster was assigned to groups and for the permissions were given to individual users. When the permissions were given to the group, we were able to access the data. Not sure why it was happening as even in the groups, individual users were there so according to me this shouldn't have happened. But anyways the issue is solved. If any of you guys know why did it not work even when individual user had the permissions but still it shows permission error please enlighten me as even in the databricks documentations, was not able to find anything.
