The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have been trying to understand how Object Level Security works in warehouse. Does the security mechanism that controls access to specific database objects, such as tables, views, or procedures implemented in Fabric warehouse, propagate to the sematic model built on top the same Warehouse for a certain user?
Let's say I want to restrict user A's access or to be able to view table "Room" in the semantic model. I deny his SQL granular permissions in Fabric warehouse. Is this supposed to restirct his access to the same table in Semantic model? If so, what are the commands?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @swathisudheer
Object-level security is a security mechanism that controls access to specific database objects, such as tables, views, or procedures, based on user privileges or roles. It ensures that users or roles can only interact with and manipulate the objects they have been granted permissions for, protecting the integrity and confidentiality of the database schema and its associated resources.
So theoretically, if you restrict access to a table, that user does not have access to the restricted table.
Best Regards,
Community Support Team _ Ailsa Tao