How To Find All Access Rights In Teradata
The problem with the table DBC.AccessRights is that the data is not something easily readable. Many of the columns use a 4-byte IDs. By joining a couple of tables to … Continue Reading →
Category: Teradata
Data Warehousing
Teradata Error: Cannot Find Terasso Library
Problem: Setting up a new computer with the 16.10 Teradata Tools And Utilities & other Teradata programs. When I went to setup the ODBC Connection to the using the Teradata … Continue Reading →
Flash NIC Light on SUSE Linux – Teradata Server
Problem: I needed to know the ethernet device name of an unused port on a NIC (network interface card) on my Teradata server. Using the “ethertool” utility, I was able … Continue Reading →
Unlock a Teradata User Account
1. Determine if the account is locked by failed password attempts. When the failed attempts equals the max logon attempts set in the user’s profile, the user will be displayed … Continue Reading →
Running A DIP Script in Teradata
Note: The following was run on a Teradata Express 15.10 VM. Problem: Teradata Support’s response to correcting a problem we were having with calendar functions was “running DIPCAL should successfully … Continue Reading →
Teradata Finding Which User is the CreateUID
Problem: Looking at the dbc.roles table, I want to find which user created a role. There is the 4-byte column in the table called CreateUID, which identifies the user that … Continue Reading →
Truncate Table in Teradata
Coming from SQL Server & Oracle, I wanted a quick way in Teradata to truncate all the records from a table. The issue is the word TRUNCATE is not a … Continue Reading →
Teradata Viewing Failed Logon Information
In Teradata, there is a way to view the reason that a username is not authenticating. Teradata is good about collecting information at the time of authentication. It can be … Continue Reading →
Changing a Password in Teradata
There are a couple ways to change a user’s password in Teradata. Two methods covered here are using a SQL statement in Teradata’s SQL Assistant, and the other is using … Continue Reading →
Viewing the DBS Control Records in Teradata
Problem: I was asked about the “MaxLoadTasks” setting in Teradata. There are a couple of ways to view this information. In this case I am going to show the command-line … Continue Reading →