A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database. 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.
In PostgreSQL, executing DCL is transactional, and can be rolled back.
Famous quotes containing the words data, control and/or language:
“This city is neither a jungle nor the moon.... In long shot: a cosmic smudge, a conglomerate of bleeding energies. Close up, it is a fairly legible printed circuit, a transistorized labyrinth of beastly tracks, a data bank for asthmatic voice-prints.”
—Susan Sontag (b. 1933)
“Teenage boys, goaded by their surging hormones ... run in packs like the primal horde. They have only a brief season of exhilarating liberty between control by their mothers and control by their wives.”
—Camille Paglia (b. 1947)
“If fancy then
Unequal fails beneath the pleasing task,
Ah, what shall language do?”
—James Thomson (1700–1748)