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

(0) Share

Report

Posted on by CU26070556-3

101

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!

All responses (2)

Answers (0)

Yuji Imaoka on at

Like (1)

Report

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

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

Administration > Reports > Security > User permissions
André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at

Like (1)

Report

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

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.