Authorization of Permanent Database Users - 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ā„¢
Permanent database users are defined in the database with a CREATE USER statement. After being 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.
    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.