Extensible data security not allowing user to create record for Constrained tables

(0) Share

Report

Posted on by Whites Road

HI Team,

I had a requirement to Create a security role to filter the PO based on the worker dimension (department) which will be assign to the user. I have created a query and add the display value into range and created a class to supply the value for it from the Worker dimension.

I have created a Security policy and add PurchTable as Constrain table and assigned the created query on top of it. This role work fine for view purpose, when i try to create a new Po from the user who has this XDS applied i am getting a error "cannot create a record in Purchase orders (PurchTable). Security policy permission denied."

When i try browsing internet i came to known that the if a table is enabled yes for Constrain table it will allow only view access. Now i want to have this XDS working with creation of PO kindly share your ideas to achieve this.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Sefa Duman 1,167 on at

Like (0)

Report
Copy link

Link copied!

Hi Santosh,

What is the "Operation" property for your security policy? If it is "All operation" or "Insert, Update and Delete", AX will give a security permission error.

You can try setting "Select" in "Operation" property for your security policy to be able to create new records.

Best regards,

Sefa Duman.

Was this reply helpful? Yes No