Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Data Control Language (DCL)

DCL is the language that enables or disables a user’s ability to perform tasks within Oracle. A user account without privileges has no functionality. The user cannot even log on to Oracle. This requires a privilege called CREATE SESSION. There are two types of privileges:

1. System privileges	Allow a user to perform DDL commands (e.g., CREATE TABLE, DROP INDEX)
2. Object privileges	Allow a user to issue DML commands (e.g., INSERT, UPDATE)

A command template for the granting of privileges is as follows:

				Grant
				privilege, privilege, privilege
				[on
				object name]
				To
				user account;
			

Listing 3.2 illustrates a typical GRANT command. Several of the command privileges allow the user to log on to the database, create tables, ...