Instruction set which governs access to a database
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources: "Data control language" – news · newspapers · books · scholar · JSTOR(July 2016) (Learn how and when to remove this message)
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. SQL[1] 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 is their proprietary extension for them only. 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:
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, SELECT, INSERT, UPDATE, DELETE, EXECUTE, and USAGE.
^"The SQL Standard – ISO/IEC 9075:2016 (ANSI X3.135) – ANSI Blog". The ANSI Blog. 2018-10-05. Retrieved 2020-09-19.
and 24 Related for: Data control language information
A datacontrollanguage (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (authorization)...
sublanguages, commonly: Data query Language (DQL), Data Definition Language (DDL), DataControlLanguage (DCL), and Data Manipulation Language (DML). The scope...
categories: a data query language (DQL), a data definition language (DDL), a datacontrollanguage (DCL), and a data manipulation language (DML). Sometimes a...
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database...
In the context of SQL, data definition or data description language (DDL) is a syntax for creating and modifying database objects such as tables, indices...
ControlData Corporation (CDC) was a mainframe and supercomputer company that in the 1960s was one of the nine major U.S. computer companies, which group...
The ControlLanguage (CL) is a scripting language originally created by IBM for the System/38 Control Program Facility and later used in OS/400 (now known...
A query language, also known as data query language or database query language (DQL), is a computer language used to make queries in databases and information...
printer controllanguage, which includes Hewlett-Packard's Printer Command Language (PCL). PostScript is one of the most noted page description languages. The...
SCADA (supervisory control and data acquisition) is a control system architecture comprising computers, networked data communications and graphical user...
Job ControlLanguage (JCL) is a name for scripting languages used on IBM mainframe operating systems to instruct the system on how to run a batch job or...
ControlData Institute (CDI) was an international technical vocational school created by the American ControlData Corporation in the mid-1960s. 1965 Control...
Data version control is a method of working with data sets. It is similar to the version control systems used in traditional software development, but...
DCCP—Datagram Congestion Control Protocol DCCA—Debian Common Core Alliance DCL—DataControlLanguage DCS—Distributed Control System DCMI—Dublin Core Metadata...
considerations, including data modeling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing...
Field data is data that is collected in an uncontrolled in-situ environment. Experimental data is data that is generated in the course of a controlled scientific...
programming language, data types constitute the semantics and characteristics of storage of data elements. They are expressed in the language syntax in...
Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of...
explicit control flow distinguishes an imperative programming language from a declarative programming language. Within an imperative programming language, a...
S. Department of Defense effort to create a portable programming language for data processing. It was originally seen as a stopgap, but the Defense Department...
is a program that provides language abstractions more often associated with high-level languages, such as advanced control structures (IF/THEN/ELSE, DO...
and C++ implementations, D, Rust, C#, and assembly language allow at least partial control of data structure padding, which may be useful in certain special...
data librarian, or a data scholar. A data modeling language and notation are often represented in graphical form as diagrams. A data model can sometimes...
Command language – a language used to control the tasks of the computer itself, such as starting programs Configuration language – a language used to...