Portlet Permissions

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

The Teradata Viewpoint Administrator can grant access to portlet views using the Portlets tab.

Permission Name Description Dependency Portlets Displaying Setting
Admin for All Workflows Enables a non-admin role to edit and manage all workflows   MAPS Manager
Enable portlet settings Enables role to access the Settings view in this portlet.   The Enable portlet settings check box is only available for portlets that have a Settings view.
Share portlet Enables role to share customized versions of the portlet with other users. After this setting is enabled, the user can click in the portlet and select Share.   The Share portlet check box is only available for portlets that can be shared.
Abort Host Enables role access to the Abort Host console utility   Remote Console
Abort Job Enables role to abort jobs that are running
  • View System
Stats Manager
Abort Process Enables role access to the list in the summary view to abort non-idle processes that are running on Teradata Aster
  • View Summary
Query Monitor
Abort Query Enables role access to the list in the summary view to abort queries
  • View Summary
My Queries, Query Groups, Query Monitor, Workload Monitor
Add Space Enables role to reallocate permanent disk space from one Teradata Database to another   Space Usage
Allocation Grid Enables role access to the Cylinder Allocation by Temperature and Grade view   TVS Monitor
Approve Recommendations Enables role to approve or reject recommendations
  • View System
Stats Manager
Automate Enables role to automate and deautomate statistics
  • View System
Stats Manager
BAR Admin Enables role to administrate the BAR Operations portlet   Bar Operations
Change Priority Enables role access to the list in the summary view allowing role to change the priority of a query or session   My Queries, Query Groups, Query Monitor, Workload Monitor
Change Workload Enables role access to the list in the summary view to change the workload of a query or session   My Queries, Query Groups, Query Monitor, Workload Monitor
Check Table Enables role access to the Check Table console utility   Remote Console
Clear Alert Enables role to clear an alert for a component, process, or resource   Unity
Clear Operation Enables role to clear Unity operation details   Unity
Configure Enables role access to the Configure console utility   Remote Console
Create Event Enables role to create calendar events   Viewpoint Calendar
Current Distribution Enables role access to the Cylinder Distribution by Grade view   TVS Monitor
DBS Control Enables role access to the DBS Control console utility   Remote Console
Edit Any Event Enables role to edit any events, including events created by other users   Viewpoint Calendar
Edit Collect Settings Enables role to set collect settings and user importance
  • View System
Stats Manager
Edit Configurations Enables role to edit the QueryGrid configuration, run a diagnostic check, run a bandwidth test and delete active issues   QueryGrid™
Edit Job Enables role to create, edit, and delete jobs
  • View System
Stats Manager, Performance Data Collection
Edit Own Event Enables role to only edit their own calendar events   Viewpoint Calendar
Edit Rulesets Enables role to edit rulesets for Teradata Aster and Teradata Database   Workload Designer
Enable Clear Alert Enables role to clear an alert for a component, process, or resource   Ecosystem Explorer
Enable Partial Size Enables role access to run SQL queries on the system to retrieve and calculate the precise size of a partial table, a table with a WHERE clause. Affects partial table size only   Data Mover
Enable State Change Enables role to change a state   Ecosystem Explorer
Enable Table Validation Enables role to validate tables in multiple systems   Ecosystem Explorer
Ferret Enables role access to the Ferret console utility   Remote Console
Gateway Global Enables role access to the Gateway Global console utility   Remote Console
Get Explain from DB Enables a single query refresh option. Allows the user to view the latest Explain steps retrieved from the database   My Queries, Query Groups, Query Monitor
Historical Distribution Enables role access to the Historical Cylinder Distribution by Grade view   TVS Monitor
Lock Display Enables role access to the Lock Display console utility   Remote Console
Manage Lab Groups Enables role to create, edit, and delete lab groups   Data Labs
Select the View Reports permission when this permission is selected.
Manage Maps Enables role to view map details, create and delete a sparse map, and manage or revoke grants   MAPS Manager
Operator Console Enables role access to the Operator Console console utility   Remote Console
Priority Scheduler Enables role access to the Priority Scheduler console utility   Remote Console
Query Configuration Enables role access to the Query Configuration console utility   Remote Console
Query Session Enables role access to the Query Session console utility   Remote Console
Recovery Manager Enables role access to the Recovery Manager console utility   Remote Console
Release Query Enables role access to the list in the summary view to release a query that is in the delay queue and waiting to run   My Queries, Query Groups, Query Monitor, Workload Monitor
Routing Actions Enables role to deploy and import session routing rules   Unity Setup
Run Job Enables role to select Run now for analyze and collect jobs
  • View System
Stats Manager, Performance Data Collection
Session Action Enables role to move, fail over, kill, or abort sessions   Unity
Session Drilldown Enables role to view details of each session from the Account String, Session, User, or Utility reports for Teradata Database and Teradata Aster
  • View Summary
  • Account
  • Account Drilldown
  • All
  • My Criteria
  • User
  • User Drilldown
  • Utility
  • Partition Drilldown
Query Monitor
Show Locks Enables role access to the Show Locks console utility   Remote Console
Space by Database Enables role to select By Database in the Select Report dialog box for Teradata Aster and Teradata Database   Space Usage
Space by Node Enables role to select By Node in the Select Report dialog box for Teradata Aster and Teradata Hadoop   Space Usage
Space by Table Enables role access to the details view with a list of tables in each database for Teradata Aster and Teradata Database   Space Usage
Space by Vproc Enables role to select By Vproc in the Select Report dialog box for Teradata Database   Space Usage
State Change Enables role to change the state in the Table Health view of the Unity portlet   Unity
Teradata DWM Dump Enables role access to the Teradata DWM Dump console utility   Remote Console
Unlock Rulesets Enables role to unlock any ruleset for Teradata Aster and Teradata Database
  • View Rulesets
Workload Designer
Update Space Enables role access to the Update Space console utility   Remote Console
View Block Enables role to see that a query is blocked. The Blocked By tab is visible, but contains no details
  • View Summary
SQL Scratchpad
View Block Details Enables role access to the content of the Blocked By tab
  • View Summary
  • View Block
SQL Scratchpad
View Blocked By Enables role access to the Blocked By tab
  • View Summary
  • Session Drilldown
My Queries, Query Groups, Query Monitor, Query Spotlight, Workload Monitor
View Blocking Enables role access to the Blocking tab when connected to Teradata Database 15.0 and later
  • View Summary
  • Session Drilldown
Query Monitor
View Canary Query Enables role to view canary queries in the summary view   Canary Response Times, Productivity
View DBQL Metrics Enables role to view the Queries Per Hour metrics   Productivity
View Delay Enables role access to the Delay tab
  • View Summary
  • Session Drilldown
My Queries, Query Groups, Query Monitor, Workload Monitor
View Detail Enables role access to the details view
  • View Summary
Alert Viewer, Completed Queries, My Queries, Node Monitor, Query Groups, Query Spotlight, Service Health, System Health, Workload Health, Workload Monitor
View Explain Enables role access to the Explain tab containing the confidence level indicator
  • View Summary
  • Session Drilldown
Completed Queries, My Queries, Query Groups, Query Monitor, Query Spotlight, Workload Monitor
View Explain Simple Enables role access to the Explain tab
  • View Summary
SQL Scratchpad
View Maps Enables role access to the Maps tab   MAPS Manager
View Query Band Enables role access to the Query Band tab
  • View Summary
  • Session Drilldown
My Queries, Query Groups, Query Monitor, Query Spotlight, Workload Monitor
View Query Detail Enables role access to the details view for a Teradata QueryGrid query   My Queries, Query Groups, Query Monitor, Completed Queries
View Reports Enables role access to the Reports tab   Data Labs
Select this permission when the Manage Lab Groups permission is selected.
View Rulesets Enables role to view rulesets for Teradata Aster and Teradata Database   Workload Designer
View Skew Enables role to view the Skew tab
  • View Summary
  • Session Drilldown
Query Monitor
  • View Summary
  • View Detail
My Queries, Query Groups, Workload Monitor
View SQL Enables role access to the SQL tab
  • View Summary
  • Session Drilldown
Application Queries, Completed Queries, My Queries, Query Groups, Query Log, Query Monitor, Query Spotlight, Workload Monitor
View Statistics Enables role access to see statistics in the Today's Statistics view   Today's Statistics
View Summary Enables role access to the summary view   Application Queries, Completed Queries, Canary Response Times, Data Labs, Data Mover Elastic Performance, Hadoop Services, Lock Viewer, My Queries, Node Monitor, Node Resources, Productivity, Query Groups, Query Log, Query Monitor, Query Spotlight, Remote Console, Space Usage, SQL Scratchpad, Service Health, System Health, TVS Monitor, Viewpoint Monitoring, Workload Health, Workload Monitor
View System Enables role to select the system from the system selection list   MAPS Manager, Stats Manager, Performance Data Collection
View System Monitoring Enables role access to the System Monitoring tab   MAPS Manager
View Workflows Enables role access to the Object Workflows tab   MAPS Manager
Vproc Manager Enables role access to the Vproc Manager console utility   Remote Console