Chapter 3: Assigning Access Privileges

In This Chapter

arrow Controlling operations with SQL

arrow Identifying users and specifying roles

arrow Categorizing users

arrow Granting and revoking privileges

arrow Granting and revoking roles

Because databases are among the most valuable assets that any organization has, you must be able to control who has access to them, as well as what level of access to grant. SQL handles access management with the third of its main components: the Data Control Language (DCL). Whereas the Data Definition Language (DDL) is used to create and maintain the structure of a database, and the Data Manipulation Language (DML) is used to fill the database structure with data and then operate on that data, the DCL protects the database from unauthorized access and other potential problems.

Working with the SQL Data Control Language

The DCL consists of four SQL statements, and two of them — COMMIT and ROLLBACK — are discussed in Book IV, Chapter 2. The other two DCL statements — GRANT and

Get SQL All-in-One For Dummies®, 2nd Edition now with O’Reilly online learning.

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