SQL*MENU with Oracle8

From: HILDEGARD GERLACH <hildegard.gerlach_at_jrc.it>
Date: Mon, 7 Jun 1999 13:12:32 +0200
Message-ID: <375BA921.8C40478B_at_jrc.it>

I am trying to migrate a user from an Oracle 7.2.3 database on AIX to an Oracle 8.0.5 on Solaris. For the data everything is ok, the problem is that they are still using an application which uses SQL*MENU (with SETENV TWO_TASK on the AIX machine).
I have exported the following table and views from the system of the 7.2.3 version:

MENU_B_APPL
MENU_B_APPL_GRP
MENU_B_CIRCLE
MENU_B_GROUP
MENU_B_GRP_PRIV
MENU_B_INFO
MENU_B_OBJ_TEXT
MENU_B_OPTION
MENU_B_PARAM
MENU_B_PARM_XREF
MENU_B_PRIV
MENU_B_PROCEDURE
MENU_B_REF
MENU_B_USER
MENU_V_APPL_GRP
MENU_V_OPTION
MENU_V_PARM_XREF
MENU_V_GROUP
MENU_V_OBJ_TEXT
MENU_V_CIRCLE
MENU_V_PROCEDURE
MENU_V_REF
MENU_V_USER
MENU_V_PRIV
MENU_V_GRP_PRIV
MENU_V_PARAM
MENU_V_INFO
MENU_V_APPL

imported in 8.0.5 and given the grants to the user.

Using the application I get the following error after giving user name and password:
MNU-10249: No authorization to run application REMMEN02.

REMMEN02 has an entry in the table MENU_B_APPL

APPLICATION_NAME: REMMEN02
SHORT_NAME: MENU
FILE_NAME: REMMEN02
CREATION_DATE: 13-JAN-93
CREATOR: dima
VERSION_RELEASE_NR: 1
LAST_RELEASE_DATE:
MENU_DIRECTORY:
IDENTIFICATION : REMMEN02 I don't know what is missing to avoid this error message and I don't have the source code of the application. Maybe anyone has an idea.

Thanks,

Hilde Gerlach

-- 
Hilde Gerlach,  Environment Institute, TAS, Informatics Support, TP 280
JRC of the EC, I-21020 Ispra(VA),Italy
Tel: +39 0332 785638  Fax: +39 0332 789256 email:
hildegard.gerlach_at_jrc.it

Received on Mon Jun 07 1999 - 13:12:32 CEST