16.10 - Automatic Privileges - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K
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, Teradata Database 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 SQL Data Definition Language Syntax and Examples.

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.