GENERATE INSTALLAUTH

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

Scope

SQLGEN Only

SQLGEN Syntax

>> [GENERATE]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;