15.10 - Privileges Granted Automatically to a Created User - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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