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.
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd 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.
