15.00 - 15.10 - Authorization of Permanent Database Users - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

Permanent database users are defined in the database with a CREATE USER statement. Once authenticated at logon, permanent users are authorized the following privileges:

  • Privileges granted directly to the user with the GRANT statement.
  • Privileges indirectly given to the user (automatic, implicit, and inherited privileges).
  • Privileges granted to a role that has been granted to the user.
  • Note: Users with more than one role automatically have access to the default role or all their roles, as specified in the CREATE USER statement. The SET ROLE statement allows users to access roles other than their default role.