Product: TIBCO Spotfire®
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.TypeNameCause:
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.UDTInfo, and