Data control language
From Wikipedia, the free encyclopedia
(Redirected from Data Control Language)
 |
This article does not cite any references or sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. (December 2009) |
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.
[edit] See also
|
||||||||||||||||||||
 |
This database-related article is a stub. You can help Wikipedia by expanding it. |
 |
This programming language-related article is a stub. You can help Wikipedia by expanding it. |
