ALLBASE/SQL Reference Manual (36216-90216)

642 AppendixC
Sample DBEnvironment
CREASEC Command File
ADD Stacey TO GROUP AccountsPayable;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.SupplyPrice
TO AccountsPayable;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Vendors
TO AccountsPayable;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Orders
TO AccountsPayable;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.OrderItems
TO AccountsPayable;
/* The following commands create the group called Purch. All DBEUserIDs
or the groups to which they belong are made members of this group.
This group has CONNECT authority only to the PartsDBE DBEnvironment. */
CREATE GROUP Purch;
ADD PurchManagers TO GROUP Purch;
ADD PurchDBMaint TO GROUP Purch;
ADD Purchasing TO GROUP Purch;
ADD Receiving TO GROUP Purch;
ADD Warehouse TO GROUP Purch;
ADD AccountsPayable TO GROUP Purch;
ADD Tom@Wilkens TO GROUP Purch;
GRANT CONNECT TO Purch;
/* The following commands create the Manufacturing Department's */
/* group. This group has SELECT, INSERT, DELETE, and UPDATE */
/* authority for the TestData and SupplyBatches tables of the */
/* ManufDB database. */
CREATE GROUP Manuf;
ADD Henry TO GROUP Manuf;
ADD Peter TO GROUP Manuf;
GRANT SELECT,
INSERT,