Chapter 14

Providing Database Security

In This Chapter

arrow Controlling access to database tables

arrow Deciding who has access to what

arrow Granting access privileges

arrow Taking access privileges away

arrow Defeating attempts at unauthorized access

arrow Passing on the power to grant privileges

A system administrator must have special knowledge of how a database works. That’s why, in preceding chapters, I discuss the parts of SQL that create databases and manipulate data — and (in Chapter 3) introduce SQL’s facilities for protecting databases from harm or misuse. In this chapter, I go into more depth on the subject of misuse — and preventing it by the savvy use of SQL features.

The person in charge of a database can determine who has access to the database — and can set users’ access levels, granting or revoking access to aspects of the system. The system administrator can even grant or revoke the right to grant ...

Get SQL For Dummies, 8th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.