Finance | Project Operations, Human Resources, ...

Extensible data security (XDS): Table method xds() is not working

(1) Share

Report

Posted on by Community Member

Hello all!

I am working on a Security policy where I need to restrict Sales orders on the basis of Business unit/Operating unit assigned to the user. Everything is working here if i manually add data to the "MyBusinessUnits" temporary table. My issue is that the xds() method is not working and therefore the temp table is not being populated with the desired data in order to filter the Sales orders.

Below are the screenshots:

1. Properties of the Policy

2. xds method

3. Policy query

Is there any configuration that i am missing that is causing the xds() to not execute?

I have the same question (0)

All responses (5)

Answers (0)

alexmeyer.itguy 648 on at

Like (1)

Report

Sohan,

It doesn't appear that you have set up the association between your XDS policy and the role assigned to the user, in your first screenshot I would expect either the 'Context String' or 'Role Name' properties to be filled out to dictate which role(s) this XDS policy would apply to.

I wrote about the XDS feature here: alexdmeyer.com/.../

And another Microsoft MVP Andre Arnaud de Calavon: dynamicspedia.com/.../

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi Sohan,

The context string and role name can be blank. In that case the policy would be active for all non-administrator users.

Have you verified if the temporary table is set to 'TempDB' and not 'InMemory'?

Do you have business units assigned via the Organization assignments on security roles? In other words, do you have records with a business unit in the UserRoleOrganization table? More specific, you are only retrieving the first record. This could also be a LE assignment and not a business unit. Then it is also not working.

I made an example how to use the Organization assignment on operating units and XDS: dynamicspedia.com/.../

In this example, I used also the same statement, but only to find out if there was any organization assignment for this user. Otherwise, it could return all operating units. You can probably copy the sample code and change this to business units instead of retail channels.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the response Alex, Here I want the policy to be applied for all Non admin users. The policy is working 100% as the non admin users are not being able to see any Sales orders (because no records are being inserted in to MyBusinessUnits table). The problem is with the xds method only.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Andre for your response. I have already made the table as 'TempDB', and yes the business unit is assigned via the Organization assignments.

The point is that I ran the same code written in xds method and does what it is supposed to do. And as i mentioned in the question itself that I made the table regular and manually inserted the records in it. after which the policy worked just fine.

The only thing is that the xds method is not doing its job. Is ther a way i can info something or see if the method even gets called?

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi Sohan,

Did you both build the full model and also synchronized the database in your environment? If you did skip the DB sync, then the policy is not working correctly.

Was this reply helpful? Yes No