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

This question has suggested answer(s)

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

All Replies
  • 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.

    kind regards,

    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.

  • 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'

     

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

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

  • 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?

    kind regards,

    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.

  • 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.

  • 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.

    kind regards,

    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.