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"
book
Article ID: KB0080840
calendar_today
Updated On:
Products
Versions
Spotfire Server
All Versions
Description
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.
Resolution
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.
Issue/Introduction
This article describes cause and resolution for given error while creating stored procedure in Spotfire based on Teradata datasource.
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