Menu Close

Users Security Roles Inquiry

Get all related security roles for users
below is a job and you can create query and form for visual view

static voidFT_UserRoleInquiry(Args _args)
{
    UserInfo        _UserInfo;
    SecurityRole    _SecurityRole;
    SecurityUserRole    _SecurityUserRole;
   
   whileselect * from_UserInfo join _SecurityUserRole where _SecurityUserRole.User == _UserInfo.id join _SecurityRole where _SecurityRole.RecId == _SecurityUserRole.SecurityRole
    {
        info(strFmt(“user %1 Security %2”,_UserInfo.name,_SecurityRole.AotName    ));
    }
}

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.