Rules for End User Profiles - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.