HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE SPACEAUTH 

Generates SQL commands necessary to recreate authorities for section or
table space.

Scope 

SQLGEN Only

SQLGEN Syntax 

>> [GEN[ERATE]] SPACEAUTH  Schema File Name or '//' to STOP command >>

SchemaFileName  DBEFileSetName >> DBEFileSetName 

Parameters 

SchemaFileName          is the name of the schema file where SQLGEN
                        places the generated commands.

DBEFileSetName          is the name of the DBEFileSet for which section
                        or table space authorities have been granted.

Example 

     >> SPACEAUTH 

     ALLBASE/SQL Command Generator for SPACEAUTH

     Schema File Name or '//' to STOP command >> SPAUTH 

     Please enter DBEFileSet Names. Type @ for all, ? for a list  of
     DBEFileSet Names, or RETURN to quit.

     DBEFileSet Name >>  PURCHFS 

     Generating command to GRANT SPACE AUTHORITY ON DBEFileSet PURCHFS

     DBEFileSet Name >> Return 

Schema File Produced 

     GRANT TABLESPACE ON DBEFILESET PURCHFS
        TO PUBLIC;

     GRANT SECTIONSPACE ON DBEFILESET PURCHFS
        TO PUBLIC;

     COMMIT WORK;

MPE/iX 5.5 Documentation