17.00 - 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.00
Published
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Last Update
2021-01-23

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