Re: Help: Can't get SQL*MENU 5.0 to execute my menus

In article <3m7ev7$33d_at_dewey.csun.edu>, hbcsc277_at_huey.csun.edu (MaNgO MaDNeSs) writes:
::From: hbcsc277_at_huey.csun.edu (MaNgO MaDNeSs)
::Newsgroups: comp.databases.oracle
::Subject: Help: Can't get SQL*MENU 5.0 to execute my menus
::
::
::I have a problem executing my menus after I design them. I'm assuming that
::I have at least design privileges. I'm not really sure. If I do really
::have design privileges then I should be able to execute after generating
::and saving my test menus.
::
::Here are the steps that I took when I designed my test menu:
::
:: 1. Created a new application called MYMENU
::
:: 2. Created a menu called MYMENU
::
:: 3. Created an item called test_item with a command type of 7.
:: The command line is menu_message('This is a test');
:: I granted role access to SYSTEM_ADMIN which is the role I am
:: in and it is saved in the security table.
::
:: 4. I generated the application and then saved it.
::
:: 5. I then executed the application and then got this error message:
:: MNU-10249: No authorization to run application MYMENU.
::
:: 6. Then when I tried to re-enter my userid and password again it gave
:: me another error message:
:: MNU-10214: No authorization to run any application.
::
::We don't have the manuals for SQL*MENU ver. 5.0, but we do have the manuals
::for version 4.0 which I don't have access to at the moment.
::
::Could someone please lead me in the right direction or point out what I'm
::doing wrong?
::
:: Thanks. Your help is appreciated.
::
:: John
::--
::###########################################################################
::# _/_/_/_/_/_/_/ _/_/_/ Email: jchayachinda_at_huey.csun.edu #
::# _/ _/ _/ #
::# _/ _/ #
::# _/ _/ #
::# _/ _/ _/ #
::# _/ _/ O H N _/ _/ H A Y A C H I N D A #
::# _/_/_/ _/_/_/ #
::###########################################################################
::

-- 
 John,

  Is your role "SYSTEM_ADMIN" a SQL*MENU role or your Database role ?

  As far as I am aware these are independant of each other.

  In SQL*MENU select Action|Admin|Security to see the list of SQL*MENU roles
  within the current instance. If your role SYSTEM_ADMIN is in there
  check your user name is part of that role. If no corresponding role exists
  then this is your problem and you will need to create the role and register
  yourself in the role. Oh, and by the way, you need to be a DBA to be able
  to amend SQL*MENU roles so if you are not you'll have to get your DBA to do
  this for you. If you need any further help feel free to E-MAil me

  Hope this helps.


 Ian
+--------------------------+-------------------------+-----------------------+
| Ian Bainbridge           | bainbridge.i_at_bgers.co.uk|Phone: (44)191-216-0202|
| British Gas ERS          | Newcastle Upon Tyne, UK |            x2790      |
+--------------------------+-------------------------+-----------------------+