 |
» |
|
|
|
Generates SQL commands necessary to recreate authorities for one or more
tables of a DBEnvironment.
Scope | |
SQLGEN Only SQLGEN Syntax | |
>> [GENERATE] 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] Y [ES]} Table Name for Owner OwnerName >> 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;
|
|
