Databases Reference
In-Depth Information
evaluation and selection, DBMS maintenance, data dictionary management, and training. Finally, you will learn about the
DBA's technical responsibilities for database design, testing, and performance tuning.
Database Policy Formulation and Enforcement
Access privileges
Security
Disaster planning
Archiving
Other Database Administrative Functions
DBMS evaluation and selection
DBMS maintenance
Data dictionary management
Training
Database Technical Functions
Database design
Testing
Performance tuning
254
FIGURE 8-1
DBA responsiblities
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 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.
