Re: SQL MENU

Jeremy Russell (jeremy.russell.deletethisbit._at_usa.net) wrote:
: 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.

Users

Action	Admin	Grant access	then enter username and give
				Execute priv.

Menu Roles
Action	Admin	Security	and create/look at menu roles

: 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.

Usually only have one set of menu table per database instance.

: 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 some

     thing
: >> 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 - 11:02:17 CST