Data Control Language Statements - Analytics Database - Teradata Vantage

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
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 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.