15.00 - Rules for End User Profiles - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.