Record Level Security

(0) Share

Report

Posted on by Community Member

Hi All,

I have created a query for inventDim table and give the range as 'inventSiteId = !2 !3 !4 !5 !6'. and i created a new policy by setting this as primary table as 'inventDim' and setting this Query and i added some Constrained table to restrict the Sites for several forms and the problem i am facing is , when this policy has assigned to one of the user , he can able to see site : 1 in every forms , but when he face situation like InventDim::findOrCreate(inventDim).inventDimId in his code , the mentioned find method returns empty inventDimId , so it tries to create it and am getting error 'Cannot create inventDimId the record already exists'.

Note : i am setting the Operation property for the Policy as 'Select' only and here i am getting to restrict the other sites to the particular user. Any Idea guys??

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Mahmood Ul Hassan 69 on at

Like (0)

Report

Will you share the screen shot of your query ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

Hi Vairam,

You cannot constrain the InventDim or InventSum table without changing the x++ logic to handle all kinds of inventory transactions (create, post, etc). You can actually restrict tables like sites, warehouses and worksheet type tables like sales order lines, purchase order lines and inventory journal lines.

What do you want to achieve exactly?

Was this reply helpful? Yes No
Javirrubio 965 on at

Like (0)

Report

Hi Vairam,

XDS Security doesn't work well when you restrict InventDim or InventSum tables. An alternative approach would be to use Record Level Security instead. Would that fit your requrements?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

Here i am having a list of roles , in which they are restricted to see only particular sites in all their Forms , so i created the policy for inventDim table , but the InventDim::findOrCreate() method doesn't finding the inventDimId from the inventDim table even though the site value is given in the range of our Policy Query

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Javier Rubio,

When using Record Level Security also am facing the same Error

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi Vairam,

You need to modify your query. You should take InventSite and InventDim and join them on inventdimid, add your range of siteid in inventdim.

Create a policy and make InventSite as primary table in your policy.

I believe it will help you and resolve the issue.

Regards,

Gaurav

Was this reply helpful? Yes No
Javirrubio 965 on at

Like (0)

Report

If it fails it might be because your XDS policy is still active, don't think it's because of the Record Level Security

Was this reply helpful? Yes No
Suggested answer

XB 1,875 on at

Like (1)

Report

I have the same problem and I solve creating politcy for inventLocation instead of InventDim

Example:

http://axlearn.blogspot.com/2017/05/12-politicas-de-seguridad-nivel-de.html

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

Hi Vairam,

You can download an example on warehouse restrictions. You could change it to constrain on site level initially instead of the warehouses. Visit my blog to get access to the example(s): kaya-consulting.com/extensible-data-security-examples

Was this reply helpful? Yes No