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
The same thread is created. See community.dynamics.com/.../105441.aspx
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.
André Arnaud de Calavon | Microsoft Dynamics AX Solution architect | My blog | My company
This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.
Try this blog link: Export Data from tables or view for Users Roles in AX 2012
run this query in sql server and export the result in excel
SECURITYUSERROLE T1 CROSS
JOINUSERINFO T2 cross
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'
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.
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.
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.
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?
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.
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.