Forum Discussion
Create or modify warehouse items - can do with Contributor role
Hi, Aleh_P,
With the permission "Create or modify warehouse items." one is allowed to create and modify a warehouse which is the container. This is only possible whe you are Admin or Member at workspace level.
When referring to creating or modifying warehouse items which are inside the warehouse container, you should at least have Contributor permissions at workspace level (Data warehouse security) or at the warehouse item level.
With kind regards,
Didier (Belgium)
Hi GilbertQ
There are no any permissions on Warehouse for this user.
I want to understand does Contributor workspace role enough to work with Warehouse reagardless documentation said you need t obe memeber or admin.
I have created brand new workspace and assign Contributor role to test user. Then go and using this test uer created warehouse and tables. I do not apply andy T-SQL and internal scecurity.
Morover I think it is not relevant to Warehouse SQL security at all, because we are talking about workspace level roles and permissions to "Create or modify warehouse items". Warehouse items in MS Fabric is Warehouse object.
In fact it looks either mistake/wrong text ("Create or modify warehouse items") in the security page or some BIG security flaw.
Super UserHi Aleh_P ,
Contributor role is the minimum access we can provide to any user for collaborating (read and write access) to all the items inside a workspace.
https://learn.microsoft.com/en-us/fabric/data-warehouse/share-warehouse-manage-permissions
https://learn.microsoft.com/en-us/fabric/security/permission-model
Thanks,
Pallavi