A database privilege is a permission to access or manipulate a database object or data. Database privileges are required for most tasks in Teradata Vantage™.
Although privileges are called access rights, permissions, or authorizations, this document uses the term privilege, as in 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 do the following:
- Access, create, modify, or delete specific database objects and data
- Create and drop cloud resources
- Run 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.