16.10 - About Viewpoint Monitoring Privileges - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

All database users can benefit from using Teradata Viewpoint to monitor the database, but not all users need all Teradata Viewpoint capabilities.

You can use the examples in the following table to help determine the database monitoring functions needed by various user types, and in creating and assigning privileges to Teradata Viewpoint roles.

Role Privileges
Default Teradata Viewpoint roles
Administrator Assign this role only to the Teradata Viewpoint administrator(s).

Has all privileges (default). This role can access the functions in the Admin tool menu to configure Teradata Viewpoint alerts, users, roles, and systems.

User Includes minimal privileges
TD_SE (Teradata Solution Engineer) This role is intended for the Teradata Solution Engineer when they need access to system health and metrics. You can enable or disable this role, but do not reconfigure it.
TD_TSS (Teradata Technical Support Specialist) This role is intended for Teradata Technical Support Specialists when they need access to your system SQL. You enable or disable this role, but do not reconfigure it.
Example custom roles
Roles are based on the user types/duties shown in Types of Users.
Database Administrator Database administrators may require all Teradata Viewpoint monitoring functions to perform administrative duties in the database.

Suggested role privileges: Create a Database Administrator role that has privileges to use all portlets and portlet functions, except System Administration, which should only be accessible to the Teradata Viewpoint administrator(s).

You may find it useful to create an additional role that limits access to some portlets and functions for lower level administrators.
Database Programmer/Power User Database programmers perform functions similar to administrators, creating database objects, running ad hoc queries, and monitoring performance.

Suggested role privileges: Similar to Database Administrator, but without analytical functions.

Programmer privileges in the database are often restricted to a development database, but Teradata Viewpoint monitors all databases within the system.
Batch User Batch users run load and export utilities or perform backup, archive, and restore operations.

Suggested role privileges include:

  • For job planning: Capacity Heat Map, Space Usage, and Calendar.
  • During job execution and troubleshooting: System Health, My Queries or Query Monitor, Workload Monitor, SQL Scratch Pad, and Console Utilities.
  • Privilege to set preferences and share portlets.
Update User Users who perform miscellaneous insert/update/delete operations.

Suggested role privileges:

  • Calendar (no create or edit privileges)
  • System Health (View Summary only)
  • My Queries
  • Workload Monitor
  • SQL Scratchpad
General User Low level users that run macros and stored procedures to access data, which select data and generate reports.

Suggested role privileges:

  • Calendar (no create or edit privileges)
  • System Health (View Summary only)
  • My Queries