Database Privileges | SQL Data Control Language | Teradata Vantage - Database Privileges - Analytics Database - Teradata Vantage

SQL Data Control Language

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-07-11
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢

A database privilege is a permission to access or to manipulate a database object or data. Specific privileges are required for nearly everything that can be done in Vantage.

Although privileges are sometimes called access rights, permissions, or authorizations, this book uses the term privilege, per the ANSI/ISO SQL:2011 specifications.

Database privileges are used by administrators to control access to database objects and data, and to control the types of actions and activities available to users. For a complete list of privileges, see Privilege Dictionary.

The privileges are used to control which users can:
  • Access, create, modify, or delete specific database objects and data
  • Execute specific macros, procedures, and UDFs
  • Monitor system-wide activity
  • Grant privileges to other users

Teradata Data Control Language (DCL) requests grant and revoke the privileges that enable users to perform these actions and activities.

To grant a privilege, the user must have the privilege on the object and the right to grant the privilege.