17.10 - Granting Privileges to Permanent Database Users - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

Grant privileges directly to users with the GRANT statement, documented in Teradata Vantage™ - SQL Data Control Language, B035-1149.

You must grant some privileges directly to users:
  • For privileges that you cannot grant to a role, see Limitations on Using Roles.
  • For a few users with truly unique needs, it may be more efficient to grant required privileges directly to the individual users.

Where possible, avoid granting privileges directly to users. Instead, grant privileges to roles and then grant role membership to users with similar database access needs. See Using Roles to Manage Privileges.