These are the database users and roles.
| User | Organization | Description |
|---|---|---|
| System Administrator | Teradata | Creates organizations. Deletes environments. |
| Automated Database Services | Teradata | Updates status. Moves log data. Provides automation of upgrades. |
| Organization Admin | Customer | Creates environments. Creates, edits, or deletes other organization admins. Creates database users. |
| Database Admin | Customer | Performs Primary Database Administrator (DBC) tasks. |
| Database User | Customer | Uses environments. |
Database users can be assigned a number of different roles when they are created.
- TD_COMPUTE_CLUSTER_ADMIN (Compute Cluster Admin)
- Create, edit and delete compute groups
- TD_CONF_REPORTS_USER (Conf Reports User)
- View and create user reports, and refresh data for these reports
- TD_CURRENT_QUERIES_ADMIN (Current Queries Admin)
- View and cancel current queries of all users
- TD_CURRENT_QUERIES_VIEW (Current Queries View)
- View current queries of all users
- TD_DATA_MODEL_ADMIN (Data Model Admin)
- Create an industry model database and reference tables in it
- TD_DATA_SCIENTIST (Data Scientist)
- Access Open Analytics Framework APIs
- TD_ENVIRONMENT_ADMIN (Environment Admin)
- Grant self-service management permissions for data protection, including backup and restore schedule creation and updates
- TD_QM_ADMIN (QM Admin)
- View the current and completed queries for all users and cancel actively running queries in the unified queries summary
- TD_QM_VIEW (QM View)
- View current and completed queries of all users in the unified queries summary
- TD_QUERY_HISTORY_VIEW (Query History View)
- View the query history of all users
- TD_SYS_CONF_REPORTS_USER (Sys Conf Reports User)
- View and refresh system reports
- TD_USER_ADMIN (User Admin)
- View users