1 Reply Latest reply on Jun 14, 2017 10:09 AM by Ramesh Reddy

    User access permission to access database using teiid.

    Kulbhushan Chaskar Master

      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

       

      Thanks,

      Kulbhushan Chaskar.