Service Account Access granted still getting as User does not have USE SCHEMA on Schema
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2024 03:50 PM
Hi All,
We have ran into scenario, where Azure Data Factory connecting to Azure Data Bricks through linkedServices,
Where its trying to connect with System Assigned Managed Identity (SAMI).
Specific SAMI added to compute and unity catalog for usage.
show grants `6b3xxxx-0xx9-4xx4-axx9-bxxxxxxbc` on schema dev.uef_db;
-----------------------------
Principal ActionType ObjectType ObjectKey
6b3xxxx-0xx9-4xx4-axx9-bxxxxxxbc USE SCHEMA CATALOG devBut, still when we try to query or execute any notebooks from ADF LinkedServices (compute/delta lake connector)
User does not have USE SCHEMA on Schema 'dev.uef_db'. SQLSTATE: 42501
Any idea, where we missing permissions.
Thanks in Advance.