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"
Article ID: KB0080840
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:
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:
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.
Issue/Introduction
This article describes cause and resolution for given error while creating stored procedure in Spotfire based on Teradata datasource.
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.
Additional Information
External: Unable to access application tables
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
Feedback
Yes
No
Powered by
