We are using Teiid for data virtualization on top of different databases like Oracle, Netezza and Teradata. However we are facing issues with user permissions/access that are required for database user while creating data source. For example connection with oracle failed because database user did not have metadata access or inserts in Netezza failed because database user did not have permissions to perform batch inserts.
Is it documented anywhere that what permissions/accesses are required for Teiid datasource user for each database?
I am using teiid 9.1.3 admin api and jboss 10.0.0
Permissions on individual databases vary greatly, Teiid assumes that the connecting user has sufficient permissions to carry over any task that it has been asked to. The restrictions are not documented. This no different than, if you were to write any JDBC application trying to connect to Oracle or trying to do insert into Netezza.