GENERATE PROCAUTH

Generates SQL statements necessary to recreate authorities for one or more procedures in a DBEnvironment.

Scope

SQLGEN only

SQLGEN Syntax

>> [GEN[ERATE]]PROCAUTH Schema File Name or '//' to STOP command >> SchemaFileName Owner Name >> OwnerName Do you wish to specify Procedure Names for each Owner (n/y)? { N[O] Y[ES] } Procedure Name for Owner OwnerName >> ProcedureName

Parameters

SchemaFileName: is the name of the schema file where SQLGEN places generated commands.
OwnerName: is the name of the owner of the procedure whose authorities you wish to generate.
NO or YES: respond NO to select all procedures for the owner; respond YES to select certain procedures for the owner.
ProcedureName: is the name of a procedure whose authorities you wish to generate.

Description

GENERATE PROCAUTH builds GRANT EXECUTE ON PROCEDURE statements to recreate authorities for one or more procedures in a DBEnvironment.

Example



   >> gen procauth



   ALLBASE/SQL Command Generator for Procedure Authority



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



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

   Owner Names, or RETURN to quit.



   Owner Name >> PurchDB

   Do you wish to specify Procedure Names for each Owner (n/y)? n



   Generating GRANT EXECUTE ON PROCEDURE PURCHDB.PROCESS12

   Generating GRANT EXECUTE ON PROCEDURE PURCHDB.REPORTMONITOR



   Owner Name >> Return



   >>

Schema File Produced



   /* This file was created with a user language environment of */

   /*    n-computer                                             */





   GRANT EXECUTE ON PROCEDURE PURCHDB.PROCESS12

      TO MANAGERS;



   GRANT EXECUTE ON PROCEDURE PURCHDB.REPORTMONITOR

      TO JACK;



   COMMIT WORK;