How to provision the access to user\ group to the specific tables in Lakehouse SQL end point

[av_9999]

Hi All,

I have a scenario to provide the access to specific tables in lakehouse endpoint for specific users\ group.

Appreciate any inputs.

[v-huijiey-msft]

Hi @av_9999 ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[v-huijiey-msft]

Hi @av_9999 ,

To provide specific users or groups with access to specific tables in the Lakehouse SQL endpoint, you can use role-based access control (RBAC) in Microsoft Fabric.

If a user has Admin, Member, and Contributor access to a workspace, they can view all OneLake folders for that workspace. the RBAC role is only for the Viewer role of the workspace. If a user does not have a workspace role, but has Lakehouse permissions, the RBAC role can be used for the following purposes:

If the user has the Read permission, access to certain folders is granted.

If the user has the ReadAll permission, access to certain folders is restricted.

Please see the following documentation for more information and procedures:

Microsoft Fabric OneLake Role Based Access Control (RBAC) (mssqltips.com)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!