Database Profiles | Teradata Vantage - 17.10 - Working with Database Profiles - 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)

You can create profiles to define resource parameters for groups of users with similar needs, rather than defining them for individual users. Then specify the profile name in a CREATE or MODIFY USER statement to give users membership in the profile.

Profiles specify such parameters as:
  • Spool space and temporary space allocations
  • Password control settings
  • Default database assignment
  • User account assignments
  • Row level security constraint assignments