Applied on:
Microsoft Dynamics® Ax 2012,Ax 2012 R2,Ax 2012 R3.
audience:
This article is for both Ax Technical & functional consultants including Administrators.
About this article:
Some times we need the list of roles assigned to particular user or for all users.it is very difficult to check each user roles.
we can fetch the required data from Two tables with the help of a small job.
Tables : SecurityRole & SecurityUserRole
//Naresh.D 01-05-2014
static void
SecurityRole(Args _args)
{
SecurityRole
securityRole;
SecurityUserRole
securityUserRole;
while
select RecId,name from
securityRole
join
securityUserRole
where
securityRole.RecId == SecurityUserRole.SecurityRole
//&&
SecurityUserRole.User == curUserId() //for current user roles
{
info(strFmt("%1
- %2",SecurityUserRole.User,securityRole.name));
}
}
