Generates SQL commands necessary to recreate all special authorities
for a DBEnvironment.
Scope
SQLGEN Only
SQLGEN Syntax
>> [GENERATE] 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@SERED
Generating Special Authority for JOHN@BROCK
. .
. .
. .
>>
Schema File Produced
GRANT DBA TO AJ@SERED;
GRANT DBA TO JOHN@BROCK;
.
.
.
COMMIT WORK;