Rules for End User Profiles - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Rules for End User Profiles

The following rules apply to all user profiles except Batch_Profile:

  • All users belong to one or more task profiles.
  • Users inherit their privileges from the task profiles to which they belong.
  • A user can belong to more than one task profile.
  • Privileges are granted at DATABASE or USER levels only.
  • Query_Profile and Upsert_Profile only have access to databases that contain macros, stored procedure definitions, and views exclusively.
  • Batch_Profile is the only profile that permits the base tables in Tables_Database to be accessed directly.