17.10 - Automatic Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)
Type of Automatic Privilege Explanation
User DBC The initial user in the system, user DBC, automatically has all database privileges. User DBC uses these privileges to create the administrative users and explicitly grant privileges to them. Administrative users can pass these privileges down to the users, roles, and databases they create.
The creator (and in some cases, the modifier) of a database, user, or object When a user with the CREATE DATABASE or the CREATE USER privilege creates a new database or user, Vantage automatically grants that user creator privileges on the created object and any space that it owns.

Creator privileges differ from ownership privileges because the FROM dbname option of the CREATE DATABASE or CREATE USER statement allows use of space owned by another user.

For a list of associated privileges, see Privilege Dictionary.

For CREATE options, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

A newly created user or database The database automatically grants a set of privileges to newly created users within their defined user space. An owner or creator can revoke the automatic privileges for a newly created user.

For a list of associated privileges, see Privilege Dictionary.