HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE SPECAUTH 

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@SERED
     Generating Special Authority for JOHN@BROCK
                .                  .
                .                  .
                .                  .
     >>

Schema File Produced 

     GRANT DBA TO AJ@SERED;

     GRANT DBA TO JOHN@BROCK;
           .
           .
           .
     COMMIT WORK;

MPE/iX 5.5 Documentation