Data control language

A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (Authorization). In particular, it is a component of Structured Query Language (SQL).

Examples of DCL commands include:

GRANT to allow specified users to perform specified tasks.
REVOKE to cancel previously granted or denied permissions.

The operations for which privileges may be granted to or revoked from a user or role may include CONNECT, SELECT, INSERT, UPDATE, DELETE, EXECUTE, and USAGE.

In the Oracle database, executing a DCL command issues an implicit commit. Hence you cannot roll back the command.

In PostgreSQL, executing DCL is transactional, and can be rolled back.

Database management systems

Types	Object-oriented comparison Relational comparison Document-oriented Graph NoSQL NewSQL

Concepts	Database ACID CAP theorem CRUD Null Candidate key Foreign key Primary key Superkey Surrogate key Armstrong's axioms

Objects	Relation table column row View Transaction Log Trigger Index Stored procedure Cursor Partition

Components	Concurrency control Data dictionary JDBC XQJ ODBC Query language Query optimizer Query plan

Functions	Administration and automation Query optimization Replication

Related topics	Database models Database normalization Database storage Distributed DBMS Federated database system Referential integrity Relational algebra Relational calculus Relational database Relational DBMS Relational model Object-relational database Transaction processing

This article is issued from Wikipedia - version of the Thursday, March 31, 2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.

Data control language

See also