O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required