Database Privileges - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qia1556235689628.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1091
lifecycle
previous
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 they are acquired by a user.

Privilege Description
Implicit (Ownership) Privileges implicitly granted by the database to the owner of the space in which database objects are created.
Automatic Privileges automatically provided by the system to:
  • The creator of a database, user, or other database object.
  • A newly created user or database.
Inherited Privileges that are passed on indirectly to a user based on its relationship to another user or role to which the privileges were granted directly.
  • Directory users inherit the privileges of the database users to which they are mapped. Directory users who are members of groups also inherit the privileges defined in external roles to which the groups are mapped.
  • All users inherit the privileges of PUBLIC, the default database user, whether or not they have any other privileges.
Explicit (GRANT) Privileges granted explicitly to a user or database in one of the following ways:
  • GRANT directly to a user or database.
  • GRANT to a role, then GRANT the role to one or more users.