Microsoft Dynamics AX (Archived)

XDS - Constrained Table

(0) Share

Report

Posted on by JoshuaRamaditya

135

Hi all,

I have a problem with constrained table.

I want to constrained table InventSite, but the problem is InventSite is my primary table at security policy.

the goal is I want to restrict the lookup data from site. example, if I want to create new PO there's a site lookup, I want to restrict the site from create PO with security policy.

any suggestion?

I appreciated any help you provided,

thank you

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Sefa Duman 1,167 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can also restrict primary table in security policy.

Select "Yes" on "ConstrainedTable" property in security policy you have created. So that, the policy restricts the data values in records that are returned from the primary table.

Kind regards,

Sefa Duman.

Was this reply helpful? Yes No
JoshuaRamaditya 135 on at

Like (0)

Report
Copy link

Link copied!

Hi Sefa,

I already select Yes on Constrained table property in security policy. the result is same, the primary table data is not affected security policy.

any another suggestions?

thanks

Was this reply helpful? Yes No
Suggested answer

Khurshid Wali 928 on at

Like (0)

Report
Copy link

Link copied!

Hi JoshuaRamaditya,

Check if you have removed System Adminstrator Role!

Also check you have enabled the policy.

if problem still persist check and share your query.

Was this reply helpful? Yes No
JoshuaRamaditya 135 on at

Like (0)

Report
Copy link

Link copied!

Hi Khurshid,

yes I already removed system admin role. also enabled the policy

Was this reply helpful? Yes No
Khurshid Wali 928 on at

Like (0)

Report
Copy link

Link copied!

then please share your "AOT Query" screenshots. Make Sure all Data sources and Ranges are visible.

regards,

Khurshid Wali

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Joshua,

You may also find some information in my blog related to securing warehouses (and related tables). kaya-consulting.com/extensible-data-security-examples-secure-by-warehouse

You can find an example for download, so you can also compare your efforts with it.

If the policy is not working, it might be caused to the query or possibly another overlapping policy. Also check if the lookup form is actually presenting data using the InventSite as datasource or if another table name from e.g. a view is used.

Was this reply helpful? Yes No