Re: SQL*Menus dveloper's access

In article <23s296$3c3_at_gaia.ucs.orst.edu>, mickel_at_OES.ORST.EDU (Paul Mickel) writes...
>
>Greetings All,
>
>I have another question for the grp. What actions must the DBA go thru to give
>a developer the ability to develop menus and execute them to test them under
>SQL*Menu. Our DBA doesn't know, because no one has ever used this before, and
>everytime I attempt to run a menu item under the application I built, I get a
>"MNU-10214: No authorization to run any application" error. From talking to our
>-Paul
>
>--
>Paul M. Mickel Internet:mickel_at_oes.orst.edu
>Database Programmer, Teledyne Wah Chang Albany, OR 97321
>Disclaimer: My employer never claims my opinions (unless it makes a profit).

Here are some of my notes on SQL*MENUs 5.0:

Make sure you have run ORA_SQLMENU50:SETUPMNU.COM   You can check this by going into SQLPLUS and running   SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME LIKE 'MENU%';   If you see any tables you should be OK.

If you get MNU-10249, go into SQLMENU Action-Admin-Security and add the user to one of the user groups.

If you get MNU-10256, at the OS prompt say

   GENMENU SYSTEM/MANAGER appname -ga user

-ga grants administrative rights, you may want to grant less.

I'm sure I've run into the error you did, but I didn't write down the solution. I bet it is to go into SQLMENU Action-Admin-Grant access. Please write back with the definitive answer so I can include it in my notes.

Hope that helps.

Jeff Chamblee Received on Fri Aug 06 1993 - 20:11:01 CEST