O'Reilly logo

SQL All-in-One For Dummies®, 2nd 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 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

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