Databases Reference
In-Depth Information
11
DATA ACCESS
AND SECURITY
Starting Point
Go to
www.wiley.com/college/gillenson
to assess your knowledge of data
access and security.
Determine where you need to concentrate your effort.
What You'll Learn in This Chapter
▲
Database connectivity concepts and requirements
▲
Server and database access control
▲
How to protect data against unauthorized access and modification or data
loss
After Studying This Chapter, You'll Be Able To
▲
Design a database solution that meets connectivity requirements
▲
Select appropriate client and application interface options
▲
Design a database solution that includes multitier connectivity
▲
Create and manage server and database security principals
▲
Control server and database access
▲
Manage and monitor the connection process and active connections
▲
Incorporate access permissions into a database design
▲
Select appropriate physical data storage options
▲
Design a backup plan that addresses the what, when, where, and how of
data backups