Database Privileges - Analytics Database - Teradata Vantage

Database Introduction

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-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

Users can access only database objects on which they have privileges. The following table lists the types of database privileges and describes how a user acquires them.

Privilege How Acquired
Implicit (Ownership) Granted by database to owner of space where database objects are created.
Automatic Granted automatically by the system to the following:
  • Creator of database, user, or other database object.
  • Newly created user or database.
Inherited Granted indirectly to user based on relationship to another user or role to which the privileges were granted directly.

Directory users inherit privileges of database users to which they are mapped. Directory users who are members of groups also inherit privileges defined in external roles to which the groups are mapped.

All users inherit privileges of default database user PUBLIC.

Explicit (GRANT) Granted explicitly to user or database in one of the following ways:
  • GRANT directly to user or database.
  • GRANT to role, then GRANT role to one or more users.