Vantage Privileges | Teradata Vantage - 2.2 - Vantage Privileges - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Release Date
January 2021
Content Type
Configuration
Implementation
Publication ID
B700-4014-011K
Language
English (United States)

Users can access only the database objects (databases, tables, views, macros, procedures, and so on) for which they have privileges. The following table lists the types of 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.
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.

Roles, external roles, and profiles are used to assign privileges to users.

Type Description
Roles Roles are used to define privileges on database objects for groups of users with similar needs, rather than granting the privileges to individual users. Roles require less dictionary space than individually granted privileges.
External Roles External roles are used to assign privileges to directory users because those users do not exist in the database.
Profiles To simplify user management, an administrator can define a profile and assign it to a group of users who share similar values for the following types of parameters:
  • Default database assignment
  • Account strings permitted
  • Password security attributes