SQL For Dummies, 8th Edition

Chapter 14

Providing Database Security

In This Chapter

Controlling access to database tables

Deciding who has access to what

Granting access privileges

Taking access privileges away

Defeating attempts at unauthorized access

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 ...