HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE INSTALLAUTH 

Generates GRANT INSTALL commands necessary to recreate all the Module
Authorities in the DBEnvironment.

Scope 

SQLGEN Only

SQLGEN Syntax 

>> [GEN[ERATE]]INSTALLAUTH  Schema File Name or '//' to STOP command >>

SchemaFileName  User Name >> UserName 

Parameters 

SchemaFileName          is the name of the schema file where SQLGEN
                        places the generated command.

User Name               is the user name for the modules for whom you are
                        granting authority.

Description 

   *   GENERATE INSTALLAUTH builds GRANT INSTALL commands to recreate all
       Module Authorities in the DBEnvironment.

   *   Authorities can be granted for the modules of one or more users of
       the DBEnvironment.

Example 

     >> generate installauth 

     ALLBASE/SQL Command Generator for INSTALL Authority

     Schema File Name or '//' to STOP command >> INSTPART 
     Please enter User Names. Type @ for all, ? for a list of
            User Names, or RETURN to quit.

            User Name >>@ 

     Generating Install Authorities for JIM@FRANCIS
     Generating Install Authorities for KAREN@RIZZO
                       .                   .
                       .                   .
     >>

Schema File Produced 

     GRANT INSTALL
              TO JIM@FRANCIS;

           GRANT INSTALL
              TO KAREN@RIZZO;

           COMMIT WORK;

[REV END]

MPE/iX 5.5 Documentation