Viewpoint Monitoring Privileges | Teradata Vantage - Viewpoint Monitoring Privileges - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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