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