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.