HP 3000 Manuals HP 3000 Manuals
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;