Microsoft Dynamics AX (Archived)

security roles and user relations in AX 2012

(0) Share

Report

Posted on by CRM Manager

Hello, Is there a way to export security roles assigned to users in AX - either excel or SSRS?

we can export the user's list but not the security roles assigned to each user info

user A - role1, role2 etc.,

user B - role2, role 3...

or what are the tables associated to users and their security roles?

appreciate your help

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Raj,

The table name with this information is: SecurityUserRole

You can find it in the AOT, System documentation, Tables

Note that the company assingments are stored in the table SecurityUserRoleCondition.

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Hi Andre, thanks. i looked at the security role table that contain the security role ID but couldn't find the table that store the name of the security role.

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Hi Andre thanks. I found it. in fact the SecurityRole has the description that I can join with SecurityUserRole.

thanks.

Was this reply helpful? Yes No
Suggested answer

ewills 5,990 on at

Like (0)

Report

thanks Andre

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

If you create a query with these tables as datasources and add it in the form "Document data sources" (Organization administration, setup, document management) it is possible to use it in Excel as well with the Office add-in.

Was this reply helpful? Yes No
MBrown1185 2,710 on at

Like (0)

Report

Hi Raj,

If you are running AX 2012 R2 or planning to upgrade to R2, this information is available in the standard SSRS report.

Wonder why MS didnt provide the same report for AX 2012 RTM.

Regards,

Michael Brown

Was this reply helpful? Yes No
pgattu 15 on at

Like (0)

Report

Michael

Can you please explain how to access this SSRS report?

Was this reply helpful? Yes No
Parth Pandya on at

Like (0)

Report

Please see the following blog entry for migrating security information in AX 2012

blogs.msdn.com/.../migrating-security-settings-between-different-dynamics-ax-2012-instances.aspx

Was this reply helpful? Yes No
MBrown1185 2,710 on at

Like (0)

Report

[System Administration > Reports > Licensing > Named User License Counts]

I hope you have the scheduled batch job for calculating license counts running. To check it, look for the job [Named user license count reports processing] in [System Administration > Inquiries > Batch Jobs]

Regards,

Michael

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (2)

Report

i'm not sure on the report. But this query can return the user name, role and the permission they have in each company.

SecurityRole securityRole;

SecurityUserRole UserRole;

SysUserInfo userInfo;

OMUserRoleOrganization roleOrganization;

OMInternalOrganization internalOrganization;

while select ID from userInfo

order by id asc

outer join UserRole

where UserRole.User == userInfo.Id

outer join securityRole

where securityRole.RecId == UserRole.SecurityRole

outer join roleOrganization

where roleOrganization.User == userInfo.Id

&& roleOrganization.SecurityRole == UserRole.SecurityRole

outer join internalOrganization

where internalOrganization.RecId == roleOrganization.OMInternalOrganization

{

print userInfo.Id, userInfo.Email, SysLabel::labelId2String(securityRole.Name), internalOrganization.Name ? internalOrganization.Name : "All Company";

pause;

}

Was this reply helpful? Yes No