Database Reference
In-Depth Information
Paige, whose responsibility is customer mailings at Premiere Products, clearly requires access to custo-
mers
names and addresses, but what about their balances or credit limits? Should she be able to change an
address? Should she be able to retrieve customers
'
'
balances or credit limits? Figure 8-3 illustrates the permit-
ted and denied access privileges for Paige.
DBMS
Access
denied
Paige
Access
permitted
259
Customer
CustomerNum CustomerName
City
State
Zip
Street
Balance
CreditLimit RepNum
148
Al's Appliance
and Sport
2837 Greenway
Fillmore
FL
33336
$6,550.00
$7,500.00
20
282
Brookings
3827 Devon
Grove
FL
33321
$431.50
$10,000.00
35
Direct
356
Ferguson's
382 Wildwood
Northield
FL
33146
$5,785.00
$7,500.00
65
408
The Everything
1828 Raven
Crystal
FL
33503
$5,285.25
$5,000.00
35
Shop
462
Bargains
3829 Central
Grove
FL
33321
$3,412.00
$10,000.00
65
Galore
524
Kline's
838 Ridgeland
Fillmore
FL
33336
$12,762.00
$15,000.00
20
608
Johnson's
372 Oxford
Sheldon
FL
33553
$2,106.00
$10,000.00
65
Department
Store
687
Lee's Sport
282 Evergreen
Altonville
FL
32543
$2,851.00
$5,000.00
35
and Appliance
725
Deerield's
282 Columbia
Sheldon
Fl
33553
$248.00
$7,500.00
35
Four Seasons
842
All Season
28 Lakeview
Grove
FL
33321
$8,221.00
$7,500.00
20
FIGURE 8-3
Permitted and denied access privileges for Paige
Although rep 20 (Valerie Kaiser) should be able to obtain some of the information about her own custo-
mers, should she be able to obtain the same information about other customers? Figure 8-4 illustrates the
permitted and denied access privileges for Valerie.
