16.10 - Working with Database Profiles - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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