namespace GB5Shared.Authorization
{
    // Required index: IX_MMENU_MENUCODE ON MMENU (MENUCODE)
    // Required index: IX_MROLEVSMENU_ROLEID_MENUID ON MROLEVSMENU (ROLEID, MENUID)
    public static class MenuRightsQB
    {
        public const string GET_ALLOW_FOR_ROLE_AND_MENUCODE = @"
            SELECT rvm.ALLOW
            FROM   MROLEVSMENU rvm
            JOIN   MMENU m ON m.MENUID = rvm.MENUID
            WHERE  m.MENUCODE = @MenuCode
              AND  rvm.ROLEID = @RoleId";
    }
}