Database Reference
In-Depth Information
DATABASE POLICY FORMULATION AND ENFORCEMENT
The DBA formulates database policies, communicates those policies to users, and enforces them. Among the
policies are those covering access privileges, security, disaster planning, and archiving.
Access Privileges
Access to every table and field in a database is not a necessity for every user. Sam, for example, is an employee
at Premiere Products; his main responsibility is inventory control. Although he needs access to the entire Part
table, does he also need access to the Rep table? It is unlikely. Figure 8-2 illustrates the permitted and denied
access privileges for Sam.
258
Rep
RepNum
LastName
FirstName
Street
City
State
Zip
Commission
Rate
20
Kaiser
Valerie
624 Randall
Grove
FL
33321
$20,542.50
0.05
35
Hull
Richard
532 Jackson
Sheldon
FL
33553
$39,216.00
0.07
65
Perez
Juan
1626 Taylor
Fillmore
FL
33336
$23,487.00
0.05
Access
denied
DBMS
Access
permitted
Sam
Part
PartNum
Description
OnHand
Class
Warehouse
Price
AT94
Iron
50
HW
3
$24.95
BV06
Home Gym
45
SG
2
$794.95
CD52
Microwave Oven
32
AP
1
$165.00
DL71
Cordless Drill
21
HW
3
$129.95
DR93
Gas Range
8
AP
2
$495.00
DW11
Washer
12
AP
3
$399.99
FD21
Stand Mixer
22
HW
3
$159.95
KL62
Dryer
12
AP
1
$349.95
KT03
Dishwasher
8
AP
3
$595.00
KV29
Treadmill
9
SG
2
$1,390.00
FIGURE 8-2
Permitted and denied access privileges for Sam
