Data Control Language | SQL Fundamentals | Teradata Vantage - Data Control Language - Advanced SQL Engine - Teradata Database

SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
zwv1557098532464.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1141
lifecycle
previous
Product Category
Teradata Vantage™

The SQL Data Control Language (DCL) is a subset of the SQL language and consists of all SQL statements that support the definition of security authorization for accessing database objects.

Purpose

Data control statements perform the following functions:
  • Grant and revoke privileges
  • Give ownership of a database to another user

Rules on Entering DCL Statements

A data control statement can be entered as:
  • A single-statement request
  • The solitary statement, or as the last statement, in an “explicit transaction” (one or more requests enclosed by user-supplied BEGIN TRANSACTION and END TRANSACTION statement in Teradata mode, or in ANSI mode, one or more requests ending with the COMMIT keyword).
  • The solitary statement in a macro

A data control statement cannot be entered as part of a multistatement request.

Successful execution of a data control statement automatically creates and updates entries in the Data Dictionary.

Teradata SQL DCL Statements

For detailed information about the function, syntax, and usage of Teradata SQL Data Control statements, see Teradata Vantage™ - SQL Data Control Language, B035-1149.