Chapter 3. Database Objects and Security

Databases are organized collections of related objects. SQL is used throughout the relational database industry as a common method to manage and manipulate database objects using relational operations. In this chapter, we discuss how to create and manage database objects and how to control access to them.

SQL is divided into three major categories:

• DDL (Data Definition Language) is used to create, modify, or drop database objects.

• DCL (Data Control Language) is used to control access to database objects by granting and revoking authorities and privileges.

• DML (Data Manipulation Language) is used to select, insert, update, and delete database records.