How to setup row level security in MDS (Master Data Services)

Question

SQL Server 2019 Master Data Services:

I would like to limit user access to an entity 'ProductGroup4' by attributes (column) and member (row).

I gave the user 'Update' access to attributes BrandCategory and SBUHierarchy And, I gave the user 'all' access to a specific SBU i.e. SBU 'H'.

The user is able to see/update Brand and SBU columns as per the model security. However, user can also see/update all SBUs, but not SBU 'H' only as per the Hierarchy member security. How can I get the security to work correctly?

Answer 1

Hi @Fernandes, Zennon,

Thank you for your reaching out and welcome to Microsoft Q&A!

Please refer to Row-level security, you could follow the steps in this article.

Please let me know in time if I have any misunderstanding.

I hope this helps! If you have any more issues or need further assistance, feel free to share with us!

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications