Re: Sql*Menu - access permissions.

Badrish Davanagere (badri_at_elm.circa.ufl.edu) wrote:

: When I try running sqlmenu (5.0) it comes up with a
: error message saying that I don't have access permissions
: to Sql*Menu even though I was trying to access it
: using a userid which has DBA privelages. Anyone know
: what to do?

After install only SYSTEM-user has access privileges to sqlmenu.

You can use command genmenu50 :

Usage : GENMENU <applnam> userid/password <options> Options are:
-e [filename] Create a SQL*Plus export file <filename>.
-m [#] Create an application library with specified # of modules.
-p [filename] Create a library listing <Filename>.
-ge [username] Grant a user execute privileges for SQL*Menu.
-gd [username] Grant a user design privileges for SQL*Menu.
-ga [username] Grant a user administrate privileges for SQL*Menu.
-r [username] Revoke a user from SQL*Menu.
-s Suppress banner.

?                Show this help information.

• OR ***

Login to sqlmenu as SYSTEM and then grant access to that DBA account (Action/Admin/Grant Access).

Kari Pannila
pannika1_at_news.ougf.fi

--

 /*  Kari Pannila                                                   *
  *  Leppavaaran kartano, SF-02620 Espoo, Finland , puh: 90-5092583 *
  *                                                                 */