Database User Alerts | Teradata Viewpoint - Database User Alerts - Teradata Viewpoint

Teradata® Viewpoint User Guide - 26.02

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Viewpoint
Release Number
26.02
Publication Date
June 2026
Content Type
User Guide
Publication ID
B035-2206-066K
ft:locale
en-US
ft:lastEdition
2026-06-02
dita:mapPath
dvd1779831456766.ditamap
dita:ditavalPath
tky1501004671670.ditaval
ft:sourceId
dita
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
You can set up an alert action so that the database user is notified by email if there is a session or database space alert.
Notification Type Description
Domain suffix Define an email domain suffix to append to the database user name. For example, if you define teradata.com as the suffix, the database user user1 is emailed at user1@teradata.com
User mapping Define a database table or view from which Viewpoint selects and return two columns, username and email address. This approach requires that the Database Administrator creates a table or view before the database user alert is configured. The Database Administrator adds rows for specific users to receive emails. Both set and multiset are supported with Latin and Unicode as supported character sets. NOT NULL is not supported. The following example shows a sample table with a username and email.
CREATE MULTISET TABLE sysdba.user_mail ,FALLBACK , 
NO BEFORE JOURNAL, 
NO AFTER JOURNAL, 
CHECKSUM = DEFAULT, 
DEFAULT MERGEBLOCKRATIO ( 
Username VARCHAR(30) CHARACTER SET UNICODE NOT CASESPECIFIC, 
EmailAddress VARCHAR(30) CHARACTER SET UNICODE NOT CASESPECIFIC) 
PRIMARY INDEX ( Username );

The User mapping option requires the credentials to execute the query. The results of the query are cached and updated by Viewpoint once a day.

Enable Ldap Database User Alerts Choose this option if LDAP configuration has been set up on the LDAPServers Admin Portlet, and the corresponding database, for which alert functionality is required. Note that alerts are only sent if the LDAP user has previously signed on to Viewpoint.

After database user alerts are configured in the Alerts Setup portlet, they are available in the Monitored Systems portlet for session and database space alerts.