ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 641
Sample DBEnvironment
CREASEC Command File
/* group. This group has SELECT, INSERT, DELETE, and UPDATE*/
/* authority for the Orders and OrderItems tables of the */
/* PurchDB database. */
CREATE GROUP Receiving;
ADD Al TO GROUP Receiving;
ADD Sue TO GROUP Receiving;
ADD Martha TO GROUP Receiving;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Orders
TO Receiving;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.OrderItems
TO Receiving;
/* The following commands create the Warehouse Department's */
/* group. This group has SELECT, INSERT, DELETE, and UPDATE */
/* authority for the Parts and Inventory tables of the */
/* PurchDB database. */
CREATE GROUP Warehouse;
ADD Kelly TO GROUP Warehouse;
ADD Al TO GROUP Warehouse;
ADD Peter TO GROUP Warehouse;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Parts
TO Warehouse;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Inventory
TO Warehouse;
/* The following commands create the Accounts Payable Department's */
/* group. This group has SELECT, INSERT, DELETE, and UPDATE */
/* authority for the SupplyPrice, Vendors, Orders, and OrderItems */
/* tables of the PurchDB database. */
CREATE GROUP AccountsPayable;
ADD Michele TO GROUP AccountsPayable;
ADD Jim TO GROUP AccountsPayable;
ADD Karen TO GROUP AccountsPayable;