GENERATE TABAUTH [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
GENERATE TABAUTH
Generates SQL commands necessary to recreate authorities for one or more
tables of a DBEnvironment.
Scope
SQLGEN Only
SQLGEN Syntax
>> [GEN[ERATE]] TABAUTH Schema File Name or '//'to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify Table
Names for each Owner (n/y)? {N[O] } Table Name for Owner OwnerName >>
{Y[ES]}
TableName
Parameters
SchemaFileName is the name of the schema file where SQLGEN
places generated commands.
OwnerName is the name of the owner for whom you wish to
generate table authorities.
NO or YES respond NO to select all table names for the
owner; respond YES to select certain table names
for the owner.
TableName is the name of a table for which you wish to
generate authorities.
Example
>> generate tabauth
ALLBASE/SQL Command Generator for Table Authority
Schema File Name or '//' to STOP command >> tabapart
Please enter Owner Names. Type @ for all, ? for a list of
Owner Names, or RETURN to quit.
Owner Name >> @
Do you wish to specify Table Names for each Owner (n/y)? n
Generating Authority for PURCHDB.INVENTORY
Generating Authority for PURCHDB.ORDERITEMS
. .
. .
>>
Schema File Produced
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PURCHDB.INVENTORY TO DBEUSERS;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PURCHDB.INVENTORY TO PURCHASING;
GRANT ALL
ON PURCHDB.INVENTORY TO PURCHDBMAINT;
. .
. .
. .
COMMIT WORK;
MPE/iX 5.5 Documentation