Forum Discussion

stellahe102's avatar
stellahe102
Helper I
1 year ago
Solved

Mirrored Database Table level security for Notebook use

Hi,   We have a mirrored database (data is mirrored from a Managed instance SQL Server) in a fabric workspace. We implemented security for users to read certain tables from the mirrored database. U...
data hub
one lake
security
workspaces
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    SQL Endpoint → respects table-level security.

    Fabric Notebooks → only respect workspace/item-level permissions, not SQL table security.

    Result: users need Lakehouse/Mirrored DB item access to use Notebooks.

    Workarounds:

    Give workspace/item read access.

    Copy allowed tables into a separate Lakehouse.

    Limitation: table-level security in Notebooks isn’t supported yet (on Microsoft’s roadmap).

Shahid12523's avatar
Shahid12523
Community Champion
1 year ago

SQL Endpoint → respects table-level security.

Fabric Notebooks → only respect workspace/item-level permissions, not SQL table security.

Result: users need Lakehouse/Mirrored DB item access to use Notebooks.

Workarounds:

Give workspace/item read access.

Copy allowed tables into a separate Lakehouse.

Limitation: table-level security in Notebooks isn’t supported yet (on Microsoft’s roadmap).