17.05 - Privileges Granted Automatically to a Created User - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
Last Update
2021-01-22

Newly created users are automatically granted the privileges needed to create and maintain objects in their space, but must be explicitly granted the privileges needed to CREATE USER/MODIFY USER or CREATE DATABASE (see also GRANT (SQL Form) in Teradata Vantage™ - SQL Data Control Language, B035-1149).

Newly created users do not receive WITH GRANT OPTION privileges for any of the automatically granted privileges.
The following privileges are automatically granted to a user when it is created.
  • CHECKPOINT
  • CREATE AUTHORIZATION
  • CREATE MACRO
  • CREATE TABLE
  • CREATE TRIGGER
  • CREATE VIEW
  • DELETE
  • DROP AUTHORIZATION
  • DROP FUNCTION
  • DROP MACRO
  • DROP PROCEDURE
  • DROP TABLE
  • DROP TRIGGER
  • DROP VIEW
  • DUMP
  • EXECUTE
  • INSERT
  • RESTORE
  • SELECT