15.00 - 15.10 - Data Control Language Statements - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

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.