Simple; Set a maintenance word on the database(s)

DButil will allow database maintenance from a non-creator user/account 
if the maintenance word is known.

"I always start things very complicated".
Mike.



Walter J. Murray wrote:
> Greetings,
>
> I am looking for a way to permit ordinary users (programmers and support
> staff) to see who is using a TurboIMAGE database, and what locks are in
> effect and are pending--the information you would see with DBUTIL using
> SHOW ... USERS and SHOW ... LOCKS or SHOW ... ALL.
>
> I have to work within these constraints:  (1) Can't let them log on with
> SM capability.  (2) Can't let them log on as the database creator.  (3)
> Can't reveal the password on the MPEX GOD program.  (4) Can't reveal the
> password on DBUTIL.
>
> Any suggestions?  Any utility to do this?
>
> My best idea so far is to set up a command file that would use the MPEX
> %WITHCAPS command to grant SM capability temporarily, then run DBUTIL.
>
> Walter  
>
> Walter J. Murray
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>   


-- 
Michael Anderson,
J3k Solutions
Sr.Systems Programmer/Analyst
832.515.3868

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *