Microsoft Dynamics AX (Archived)

how to create a list of security roles associated to users in AX 2012

(1) Share

Report

Posted on by ewills

5,990

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 (9)

Answers (0)

Suggested answer

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

Like (1)

Report

The same thread is created. See community.dynamics.com/.../105441.aspx

Answer:

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
640579632b5c4e6780a... 4,730 on at

Like (1)

Report

run this query in sql server and export the result in excel

SELECT

T1.USER_, t3.AOTNAME

FROM

SECURITYUSERROLE T1 CROSS

JOIN
USERINFO T2 cross

join

[AXDBDEV_model].[dbo].SECURITYROLE t3

WHERE

T1.ASSIGNMENTSTATUS= 1 AND T1.USER_=T2.ID and t3.RECID = t1.SECURITYROLE and t1.PARTITION = 5637144828 and

t2.name = 'Huzaifa' and t2.COMPANY ='COM'

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Try this blog link: Export Data from tables or view for Users Roles in AX 2012

axaptacorner.blogspot.ae/.../ax-2012.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, In system administration window, under "Reports" menu, click on "Users security roles" then click on "OK" a detailed users role will be loaded.

Note: Only System administrator can view "USERS SECURITY ROLES"

I hope this could be helpful.

Was this reply helpful? Yes No
bankk 6,609 on at

Like (0)

Report

Ali, I'm setup as a System Administrator but can't see this "users security roles" report you mention. Is this an OOTB report in R2? I've been trying to find something like this report. Thanks in advance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If you are using Dynamics AX 2012, just login with system admin right, then under system administration menu find the "Reports" under reports ---->Security ----->Users security Roles.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ali, Kbanh,

I checked our standard AX2012 R2 environment. This report is not available. Is it a newly created report at your company/partner?

Was this reply helpful? Yes No
bankk 6,609 on at

Like (0)

Report

Hi Andre, sorry for the newbie question but when I open AOT > Data Dictionary > Tables I can not find the SecurityUserRole table. The documentation for SecurityUserRole is there though. Is this a hidden table or only accessible through access to the SQL Server DB? Can you expand please? Thanks in advance.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

Hi Kbanh

The answer is in an earlier reply from me above...

The table can be found in AOT, System documentation, Tables

Hope this makes it clear to you.

Was this reply helpful? Yes No