O'Reilly logo

SQL For Dummies, 8th Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required