GENERATE VIEWAUTH

Generates SQL commands necessary to recreate authorities for one or more views of a DBEnvironment.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GEN[ERATE]]VIEWAUTH Schema File Name or '//' to STOP command >> SchemaFileName Owner Name >> OwnerName Do you wish to specify View Names for each Owner (n/y)? N[O] Y[ES] View Name for Owner OwnerName >> ViewName

Parameters

SchemaFileName: is the name of the schema file where SQLGEN places the generated commands.
OwnerName: is the name of the owner for whom you wish to generate view authorities.
NO or YES: respond NO to specify all view names for the owner; respond YES to specify certain view names for the owner.
ViewName: is the name of a view for which you wish to generate authorities.

Example



   >> generate viewauth



   ALLBASE/SQL Command Generator for View Authority



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



   Please enter Owner Names. Type @ for all, ? for a list of

   Owner Names, or RETURN to quit.



   Owner Name >> purchdb

   Do you wish to specify View Names for each Owner (n/y)? n



   Generating Authority for PURCHDB.PARTINFO

   Generating Authority for PURCHDB.VENDORSTATISTICS



   Owner Name >>   Return 



   >>

Schema File Produced



   GRANT SELECT

     ON PURCHDB.PARTINFO TO DBEUSERS;



   GRANT SELECT

     ON PURCHDB.PARTINFO TO PURCHDBMAINT;



   GRANT SELECT

     ON PURCHDB.PARTINFO TO PURCHMANAGERS;

           .                  .

           .                  .

           .                  .

   COMMIT WORK;

GENERATE VIEWAUTH

Technical documentation

» Table of Contents

» Index

Scope

SQLGEN Syntax

Parameters

Example

Schema File Produced