Getting a list of all users who have edit access to certain field in a form

(0) Share

Report

Posted on by CU26070556-3

Hello,
I'm searching for a method to get a list of all users or user groups who have access to a certain field in a form. The Ax version used is 2009 here. There are many users and user groups which made it difficult to find it manually.
They here don't want to change the access at the table level but need to stop through group permissions.

I'd like to know if there's any SQL script or AX job to pull the user's list who have certain access, please. Any suggestions or help is appreciable. Thanks!

I have the same question (0)

All responses (2)

Answers (0)

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

Like (1)

Report

Hi Khaja,

There is a table in the database which holds the access to tables and their fields. The link is per user group/per domain. I don't have an AX 2009 environment available to check the table name. In AX 2012, the security architecture had been changed. You can probably find the table name on the form where you do setup the permissions.

Was this reply helpful? Yes No
Yuji Imaoka on at

Like (1)

Report

Do you think that [Object permissions] report is useful for this?

Administration > Reports > Security > User permissions

Was this reply helpful? Yes No