Chapter 3
Assigning Access Privileges
IN THIS CHAPTER
Controlling operations with SQL
Identifying users and specifying roles
Categorizing users
Granting and revoking privileges
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.
