About Database Privileges | SQL Data Control Language | Teradata Vantage - 17.05 - About Database Privileges - Teradata Database

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

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 Teradata Database.

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

Teradata 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.