Data Control Language Statements - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
jiv1600056352873.ditamap
dita:ditavalPath
jiv1600056352873.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢

You use DCL statements to grant and revoke access to database objects and change ownership of those objects from one user or database to another. The results of DCL statement processing also are recorded in the Data Dictionary.

The following table lists some basic DCL statements. The list is not exhaustive.

Statement Action
GRANT/REVOKE Controls privileges of the users on an object.
GRANT LOGON/REVOKE LOGON Controls logon privileges to a host (client) or host group (if the special security user is enabled).
GIVE Gives a database object to another database object.