Set Up Users to Access Query Level Monitoring | Teradata Vantage - Setting Up Users to Access Query Level Monitoring - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Published
January 2021
Language
English (United States)
Last Update
2021-05-08
dita:mapPath
gta1588198788318.ditamap
dita:ditavalPath
dby1605127568110.ditaval
dita:id
B700-4014
Product Category
Analytical Ecosystem
Software
Teradata Vantage

To select information from the Query Level Monitoring (QLM) database, the user must be granted SELECT privilege on it. By default, DBC does not have select on that database, so DBC can also grant itself SELECT on QLM, if needed.

A good practice is to create a role that contains the SELECT privilege and then assign the role to the users that need it.
  1. From a client application (such as BTEQ or Teradata Studio), log on to the Vantage system as DBC. For example:
    .logon systemname.your_company.com/dbc
  2. [Optional] You can grant select to an existing user or create a new user. For example:
    CREATE USER rose FROM DBC AS PASSWORD=rose PERM=20000000 SPOOL=50000000 TEMPORARY = 30000000 FALLBACK;
  3. Grant SELECT on the database to the user:
    grant select on td_mle_db.querylog to rose;
  4. [Optional] Grant SELECT to DBC:
    grant select on td_mle_db.querylog to DBC;
  5. Log off:
    .logoff