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 |
|
Stats Manager |
| Abort Process | Enables role access to the  list in the summary view to abort non-idle processes that are running on an Aster system |
|
Query Monitor |
| Abort Query | Enables role access to the list in the summary view to abort queries |
|
My Queries, Query Groups, Query Monitor, Workload Monitor |
| Add Space | Enables role to reallocate permanent disk space from one 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 |
|
Stats Manager |
| Automate | Enables role to automate and deautomate statistics |
|
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 |
|
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 |
|
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 and Aster systems | 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 |
|
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 and Aster systems |
|
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 and Aster systems | Space Usage | |
| Space by Node | Enables role to select By Node in the Select Report dialog box for Aster and Hadoop systems | Space Usage | |
| Space by Table | Enables role access to the details view with a list of tables in each database for Teradata and Aster systems | Space Usage | |
| Space by Vproc | Enables role to select By Vproc in the Select Report dialog box for Teradata systems | 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 and Aster systems |
|
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 |
|
SQL Scratchpad |
| View Block Details | Enables role access to the content of the Blocked By tab |
|
SQL Scratchpad |
| View Blocked By | Enables role access to the Blocked By tab |
|
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 |
|
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 |
|
My Queries, Query Groups, Query Monitor, Workload Monitor |
| View Defer | Enables role access to the Defer tab |
|
My Queries, Query Groups, Query Monitor, Workload Monitor |
| View Detail | Enables role access to the details view |
|
Alert Viewer, Completed Queries, My Queries, Node Monitor, Query Groups, Query Spotlight, System Health, Workload Health, Workload Monitor |
| View Explain | Enables role access to the Explain tab containing the confidence level indicator |
|
Completed Queries, My Queries, Query Groups, Query Monitor, Query Spotlight, Workload Monitor |
| View Explain Simple | Enables role access to the Explain tab |
|
SQL Scratchpad |
| View Maps | Enables role access to the Maps tab | MAPS Manager | |
| View Query Band | Enables role access to the Query Band tab |
|
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 and Aster systems | Workload Designer | |
| View Skew | Enables role to view the Skew tab |
|
Query Monitor |
|
My Queries, Query Groups, Workload Monitor | ||
| View SQL | Enables role access to the SQL tab |
|
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, 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 |