Creation of Teradata stored procedure fails in Spotfire with error “[Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.UDTInfo.TypeName"

 

Creation of Teradata stored procedure fails in Spotfire with error “[Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.UDTInfo.TypeName"

 

Creation of stored procedure based on Teradata datasource in TIBCO Spotfire Analyst client > Tools > Information Designer fails with below error in the server.log:
 

Error retrieving metadata: [Teradata Database] [TeraJDBC 15.10.00.35] [Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.UDTInfo.TypeName

Cause:
This issue occurs when the account used to create the Teradata datasource in Spotfire does not have ‘select’ privileges on the following Teradata system tables:  

• DBC.Tables,
• DBC.Columns,
• DBC.UDTInfo, and
• DBC.Databases.

To resolve the issue, provide ‘select’ privileges on DBC.Tables, DBC.Columns, DBC.UDTInfo, and DBC.Databases for the account used in creation of the data source in the Information Designer. This is not a Spotfire specific issue. The Teradata database administrator needs to make sure the required privileges are set for the given account on Teradata system tables to fetch the metadata information. External: Unable to access application tables

• https://community.teradata.com/t5/Database/Unable-to-access-application-tables/td-p/58141

External: ERROR: "The user does not have SELECT access to DBC.UDTInfo.TypeName" while adding the resource for the Teradata physical data object in Developer Too

• https://kb.informatica.com/solution/23/Pages/52/313715.aspx