ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 643
Sample DBEnvironment
CREASEC Command File
DELETE,
UPDATE
ON ManufDB.SupplyBatches
TO Manuf;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON ManufDB.TestData
TO Manuf;
GRANT CONNECT TO Manuf;
/* The following commands GRANT specific authorities to */
/* specific DBEUserIDs. */
GRANT SELECT ON PurchDB.Vendors TO Tom;
GRANT SELECT ON PurchDB.VendorStatistics TO Tom;
GRANT SELECT ON PurchDB.PartInfo TO Tom;
GRANT UPDATE (BinNumber,QtyOnHand,LastCountDate)
ON PurchDB.Inventory TO Kelly;
GRANT UPDATE (BinNumber,QtyOnHand,LastCountDate)
ON PurchDB.Inventory TO Peter;
GRANT UPDATE (PhoneNumber,VendorStreet,VendorCity,
VendorState,VendorZipCode)
ON PurchDB.Vendors TO Karen;
GRANT UPDATE (PhoneNumber,VendorStreet,VendorCity,
VendorState,VendorZipCode)
ON PurchDB.Vendors TO Jim;
/* The following commands create a group called DBEUser */
/* for all other DBEUserIDs, and GRANTS specific */
/* authorities to this group. */
CREATE GROUP DBEUsers;
GRANT CONNECT TO DBEUsers;
GRANT RESOURCE TO DBEUsers;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Parts
TO DBEUsers;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Inventory
TO DBEUsers;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Vendors