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, ...