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