Automatic Privileges - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-02
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™
Type of Automatic Privilege Explanation
User DBC The initial user in the system, DBC, automatically has all database privileges. User DBC uses automatic 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.