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:
|
| Update User | Users who perform miscellaneous insert/update/delete operations. Suggested role privileges:
|
| General User | Low level users that run macros and stored procedures to access data, which select data and generate reports. Suggested role privileges:
|