GENERATE VIEWAUTH [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
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] } View Name for Owner OwnerName >>
{Y[ES]}
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;
MPE/iX 5.5 Documentation