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 == join _SecurityRole where _SecurityRole.RecId == _SecurityUserRole.SecurityRole
        info(strFmt(“user %1 Security %2”,,_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.