GENERATE PROCAUTH [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
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] } Procedure Name for Owner OwnerName
{Y[ES]}
>> 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
[REV BEG]
>> 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
>>
[REV END]
Schema File Produced
/* This file was created with a user language environment of */
/* NATIVE-3000 */
GRANT EXECUTE ON PROCEDURE PURCHDB.PROCESS12
TO MANAGERS;
GRANT EXECUTE ON PROCEDURE PURCHDB.REPORTMONITOR
TO JACK@TEST;
COMMIT WORK;
MPE/iX 5.5 Documentation