Generates SQL commands necessary to recreate all special authorities
for a DBEnvironment.
Scope
SQLGEN Only
SQLGEN Syntax
>> [GEN[ERATE]]SPECAUTH Schema File Name or '//' to STOP command >> SchemaFileName
Parameters
SchemaFileName
is the name of the schema file where SQLGEN places the generated commands.
Description
GENERATE SPECAUTH builds commands to recreate DBA, CONNECT, and RESOURCE
authorities for a DBEnvironment.
Example
>> generate specauth
ALLBASE/SQL Command Generator for Special Authority
Schema File Name or '//' to STOP command >> speapart
Generating Special Authority for AJ
Generating Special Authority for JOHN
. .
. .
. .
>>
Schema File Produced
GRANT DBA TO AJ;
GRANT DBA TO JOHN;
.
.
.
COMMIT WORK;
