GENERATE MODAUTH

Generates SQL commands necessary to recreate module authorities for one or more owners of a DBEnvironment.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GEN[ERATE]]MODAUTH Schema File Name or '//' to STOP command >> SchemaFileName Owner Name >> OwnerName

Parameters

SchemaFileName: is the name of the schema file where SQLGEN places the generated commands.
OwnerName: is the owner of the modules for which you are granting authority.

Description

GENERATE MODAUTH builds GRANT RUN commands to recreate authorities for modules stored in a DBEnvironment.
Authorities can be granted for the modules of one or more owners of the DBEnvironment.

Example

   >> generate modauth



   ALLBASE/SQL Command Generator for Module Authority



   Schema File Name or '//' to STOP command >> modapart



   Please enter Owner Names. Type @ for all, ? for a list of

   Owner Names, or RETURN to quit.



   Owner Name >> @



   Generating GRANT RUN on PURCHMANAGERS.REPORTPROG

          .             .

          .             .



   >>

Schema File Produced

   GRANT RUN ON PURCHMANAGERS.REPORTPROG

         TO PURCHDBMAINT;



   GRANT RUN ON PURCHMANAGERS.UPDATEPROG

         TO PURCHDBMAINT;



          .                    .

          .                    .

          .                    .



   COMMIT WORK;