This document describes the Teradata SQL Data Control Language (DCL) statements used to manage access to the database objects and data in the system. Teradata SQL is an ANSI compliant product. Teradata has its own extensions to the language.
Using SQL Data Control Language
- Administrators and other database users who are authorized to control database access by defining user privileges.
- Teradata technical personnel responsible for designing and maintaining Teradata Vantage™.
Why Would I Use this Content?
Learn about the statements used to manage access to the database objects and data in the system.
How Do I Use this Content?
For an overview of the Vantage privileges and a summary of the types of access control (security) that they support, see Database Privileges.
For descriptions of the statements you use to grant and revoke the privileges, see Statement Syntax.
- Descriptions of privilege table columns
- Single keywords that grant multiple privileges
- Required DBC privileges
- Required PUBLIC privileges
- Privileges need for database administration
- Determining privileges for a user
How Do I Get Started?
Read the overview of the Vantage privileges and summary of the types of access control (security) that they support, Database Privileges.
References to Other Relevant Content
For more information about Vantage security, see Teradata Vantage™ - Analytics Database Security Administration, B035-1100.
For more information about views that show which privileges are in effect, see Teradata Vantage™ - Data Dictionary, B035-1092.