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