Editing Data control language (section)

{{Short description|Instruction set which governs access to a database}}
{{More citations needed|date=July 2016}}
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). Data Control Language is one of the logical group in SQL Commands. [https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/ SQL]<ref>{{Cite web|date=2018-10-05|title=The SQL Standard – ISO/IEC 9075:2016 (ANSI X3.135) – ANSI Blog|url=https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/|access-date=2020-09-19|website=The ANSI Blog|language=en-US}}</ref> is the standard language for relational database management systems. SQL statements are used to perform tasks such as insert data to a database, delete or update data in a database, or retrieve data from a database.

Though database systems use SQL, they also have their own additional proprietary extensions that are usually only used on their system. For example, Microsoft SQL server uses Transact-SQL (T-SQL), which is an extension of SQL. Similarly, Oracle uses PL-SQL, which an Oracle-specific SQL extension. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database.

Examples of DCL commands include the SQL commands:
* GRANT to allow specified users to perform specified tasks.
* REVOKE to remove the user accessibility to [[database object]].

The operations for which privileges may be granted to or revoked from a user or role apply to both the [[Data definition language]] (DDL) and the [[Data manipulation language]] (DML), and may include [[Connect (SQL)|CONNECT]], [[Select (SQL)|SELECT]], [[Insert (SQL)|INSERT]], UPDATE, [[Delete (SQL)|DELETE]], [[Execute (SQL)|EXECUTE]], and [[Usage (SQL)|USAGE]].