Database Privileges - Teradata Database

Database Introduction

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata® Database

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.