ALLBASE/SQL Reference Manual (36216-90216)

640 AppendixC
Sample DBEnvironment
CREASEC Command File
GRANT ALL ON PurchDB.SupplyPrice TO PurchDBMaint;
GRANT ALL ON PurchDB.Vendors TO PurchDBMaint;
GRANT ALL ON PurchDB.Orders TO PurchDBMaint;
GRANT ALL ON PurchDB.Reports TO PurchDBMaint;
GRANT ALL ON PurchDB.OrderItems TO PurchDBMaint;
GRANT SELECT ON PurchDB.VendorStatistics TO PurchDBMaint;
GRANT SELECT ON PurchDB.PartInfo TO PurchDBMaint;
/* The following commands create the Purchasing Department's */
/* group. This group has SELECT, INSERT, DELETE, and UPDATE */
/* authority for the Inventory, SupplyPrice, Vendors, Orders,*/
/* and OrderItems tables of the PurchDB database. */
CREATE GROUP Purchasing;
ADD AJ TO GROUP Purchasing;
ADD Jorge TO GROUP Purchasing;
ADD Ragaa TO GROUP Purchasing;
ADD Greg TO GROUP Purchasing;
ADD Karen TO GROUP Purchasing;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Inventory
TO Purchasing;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.SupplyPrice
TO Purchasing;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Vendors
TO Purchasing;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.Orders
TO Purchasing;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PurchDB.OrderItems
TO Purchasing;
/* The following commands create the Receiving Department's */