Re: SQL MENU

Again, it's been a long long time since I used SQL*Menu, but I believe that you need to run sqlmenu, connect as a DBA, then choose admin and users (or something like that), then create an authorisation group for SQL*Menu and add the required user account names to that.

Each menu in your menu files then needs to have the group entered against it to authorise users in that group to run that menu.

There's also something in the back of my mind about installing SQL*Menu support tables into the database in either a "private" [ per user ] mode or as a shared resource ... but then again, that might be to allow developers to share the menu source code ... it's been so long that this is all very hazy and not to treated as 100% reliable.

Usual disclaimers apply ...

Jeremy Russell

Robert Pritchard <robert_pritchard_at_tertio.com> wrote:

>I have tried this and am still having problems. Is there any specific system
>table that needs altering in order to allow users to run sqlmenu?
>
>
>Kevin Loney wrote:
>
>> I believe (it's been about 7 years now) you'd use genmenu. Try putting in
>> "genmenu" by itself and seeing the help text. You'll need to do something
>> like "genmenu system/pass username -GA" to grant admin privileges.
>>
>> hth.
>> Kevin Loney
>> http://www.kevinloney.com
>>
>> Robert Pritchard wrote in message <36D3E3C3.A737803D_at_tertio.com>...
>> >How do I authorise users to run sqlmenu5? I realise I could look it up
>> >in the manual but sadly the manual got chucked out and I am somewhat
>> >stuck.
>> >Cheers
>> >Rob
>> >
>> >
>
Received on Thu Feb 25 1999 - 06:51:40 CST