Data control language

From Wikipedia, the free encyclopedia
  (Redirected from Data Control Language)
Jump to: navigation, search

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.

See also[edit]