5 Database Utilities

The DBUTIL utility

Introduction

Dbutil is used to maintain database security with the new Eloquence database.

Database changes are defined in a file using the DBUTIL script language. This makes it possible for a software vendor to provide a control script to a customer to perform database changes without manual interaction.

NOTE: The DBUTIL utility included with Eloquence A.06.00 is different than the one included with Eloquence A.05.xx. It does currently neither support database restructuring nor does it provide a dialog based user interface.

The following actions can be performed:

r Create or delete users, change user passwords

r Grant or revoke user properties

r Create or delete database specific access groups

r Grant or revoke group specific properties

r Assign users with access groups

r Grant or revoke data set specific access rights to an access group

DBUTIL commandline arguments

Synopsis:

   usage: dbutil [options] file
   options:
    -help   = show usage (this list)
    -v      = verbose          (batch mode only)
    -e cnt  = abort processing after encountering cnt errors
    -t tmp  = where temporary files are stored
    -d flg  = set debug flags
Arguments:

-v[v]
Specifying the -v option will cause dbutil to output a summary of changes after analyzing the control file and some descriptive text during the database restructuring.
Specifying two -v options will cause dbutil to echo the control file to stdout as it is analyzed.
-e cnt
Abort processing the control file after encountering the given number of syntax or validation errors.
-t tmp
This option makes it possible to specify where temporary files will be created. If the -t argument is not specified, dbutil will allocate temporary files at the default location of the operating system.
-d flags
This is used internally to debug dbutil itself. You should not use this option.
file
The name of a script file to use by dbutil. Specifying the file name - will use stdin.

DBUTIL script file syntax

The dbutil script file is a plain text file. The following general rules apply:

The syntax description below uses the following conventions:


Eloquence Database Manual - 19 DEC 2002