Cannot logon to the system - no access right to DBC.DatabaseV

Database
HS
Teradata Employee

Cannot logon to the system - no access right to DBC.DatabaseV

Hello, In our system we have a few users created months ago. Now we have created a user for which all was set (ROLE, PROFILE, PASSWORD, ACCOUNT, etc…) but I cannot log-in with this user as the system returns an error: “The user does not have SELECT access to DBC.DatabaseV.Databasename” All users created in past do not have any such access to this view and are able to connect to the system. Please can you advise me what could be wrong or what has to be corrected to be able to log-in. Thank you.

Tags (1)
2 REPLIES
Junior Contributor

Re: Cannot logon to the system - no access right to DBC.DatabaseV

Which client do you use to logon?

Afaik you don't need access rights to dbc.DatabasesV (there's no dbc.DatabaseV, i assume it's a typo) to be able to logon.

Usually SELECT on DatabasesV or DatabasesVX are granted to public...

HS
Teradata Employee

Re: Cannot logon to the system - no access right to DBC.DatabaseV

Hi dnoeth,

Indeed the problem was with PUBLIC user as it did not have any rights on VIEWs in DBC. So I have granted what was needed and I am able to connect. Thanks for you reply and for the tip.