akaRolesAndTasks

Posted by Alvin You
2013. 11. 13. 15:06 카테고리 없음

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");
}