Chapter 3

Assigning Access Privileges


Bullet Controlling operations with SQL

Bullet Identifying users and specifying roles

Bullet Categorizing users

Bullet Granting and revoking privileges

Bullet 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 4, Chapter 2. The other two DCL statements — GRANT and ...

Get SQL All-in-One For Dummies, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.