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.
-
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
-
[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;
-
Grant SELECT on the database to the user:
grant select on td_mle_db.querylog to rose;
-
[Optional] Grant SELECT to DBC:
grant select on td_mle_db.querylog to DBC;
-
Log off:
.logoff