Forum Discussion
mkjit256
Helper IV
Helper IVSELECT permissions or external policy action error. OneLake Security issue
Hello I am trying the OneLake security on a lakehouse has shortcut tables. I had created a security role in OneLake security that can only read one table from it and i had added a user to it. In ad...
Hi mkjit256,
Despite the Fabric documentation clearly supporting this scenario in principle, configuring access in SQL Endpoint via OneLake Security is still maturing. For your use case, it would be best to limit user access in:
- Lakehouse: using OneLake Security
- SQL Endpoint: Grant/Deny T-SQL statements (switch back to Delegated Identity mode)
This approach works like a charm!
stoic-harsh
Super User
Super User
Hi mkjit256,
Despite the Fabric documentation clearly supporting this scenario in principle, configuring access in SQL Endpoint via OneLake Security is still maturing. For your use case, it would be best to limit user access in:
- Lakehouse: using OneLake Security
- SQL Endpoint: Grant/Deny T-SQL statements (switch back to Delegated Identity mode)
This approach works like a charm!
mkjit256Helper IV
Helper IVThanks for your reply. I will give it a try and update