akaRolesAndTasks
static void akaRolesAndTasks(Args _args)
{
// !# August.28.13.rvanbran:
SecurityTask securityTask ;
SecurityRole securityRole ;
SecurityUserRole securityUserRole ;
SecurityRoleTaskGrant securityRoleTaskGrant ;
UserInfo userInfo ;
;
info( "User|Role|Task");
while select securityUserRole
join securityRole where securityRole.RecId == securityUserRole.SecurityRole
join securityRoleTaskGrant where securityRoleTaskGrant.SecurityRole == securityRole.RecId
join securityTask where securityRoleTaskGrant.SecurityTask == securityTask.RecId
join userInfo where userInfo.id == securityUserRole.User
&& userInfo.enable == NoYes::Yes
{
info( strFmt("%1 |%2 | %3" , securityUserRole.User, SysLabel::labelId2String2(securityRole.Name), SysLabel::labelId2String(securityTask.Name)));
}
info( "done");
}