Need to get information about users from table.

(0) Share

Report

Posted on by Community Member

hello all,

i want to know that which user has which role and privileges in ax. is it possible for me to get this information from tables? if yes then which tables can help me to get this information out? thanks

Hassan

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

Take a look at the Security* / SysSecurity* tables in System documentation > Tables > Right click > Table browse.

They are part of the AX _model database in SQL Server.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i can not find these tables in aot

Was this reply helpful? Yes No
ColbyGallagher 3,666 on at

Like (0)

Report

Dont look in the Data Dictionary node of the AOT, you need to be down in the System Documentation node.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i know. and i find from there. but i did't find anything there

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (1)

Report

Hi Hassan Ghauri,

Please check this blog post msdax.wordpress.com/.../security-jobs-related-to-dynamics-ax-2012-role-based-security it has code snippets showing how to work with this tables in AX.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi

what if i need to get a list of all users with their roles and duties as well. what i have to do with this job?

please

Was this reply helpful? Yes No
Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

The table SECURITYUSERROLE in the business database links users to security roles as assigned in the AX user interface. Then the table SECURITYUSERROLECONDITION itemizes the DATAAREA's assigned to each user/security role combination. Note that if there are no records in the SECURITYUSERROLECONDITION, then the user effectively is granted all DATAAREA. Also note that the --SYSADMIN-- role is implicitly granted access to all resources. Note that a user to security role relationship can be enabled or disabled with the ASSIGNMENTSTATUS field. And, of course, users can be enabled or disabled.

You can explode roles into sub-roles using the SECURITYROLEEXPLODEDGRAPH view in the model store to explode roles into sub-roles. Note that these relationships can be enabled or disabled, and that field is available in the output. Finally, you can explode roles into duties and privileges using the SECURITYTASKEXPLODEDGRAPH view in the model store.

In other words, if you want to explode all of this data into an accurate representation of how AX will grant security to the user, you have a lot of pieces to put together, and a lot of subtleties to understand. It gets even harder when security is implied through menu items through linked permissions.

The XU_SecurityLoadRoles stored procedure details exactly how AX compiles all of this into a cached security profile for a role or set of roles. Trust me, it's not easy to follow.

Once security is compiled for a role, that information is available in various tables in the model store, such as MODELSECURITYPERMISSIONCACHE.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (1)

Report

Rewrite it to meat your requirements. It's just an example how to work with those tables. Do you have any specific questions ? like you don't know what tables to use or maybe you don't know how to write x++ select statements.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

actually i am not technical person so i do;t know which tables can be used for this purpose. can you help me?

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

You should start by finding a technical person to work with you directly. You're not going to figure it out by trial and error with the help of an online forum.

Was this reply helpful? Yes No