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.

See also

• Data definition language
• Data manipulation language