16.20 - Privileges Granted Automatically to a Created User - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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