Hi Aamir, pls find below some information from informatica KB.See if it help.
"TPTWR_3523 : [ERROR] Type:(Teradata DBS Error), Error: RDBMS error 3523: An owner referenced by user does not have INSERT WITH GRANT OPTION access" Teradata Parallel Transporter TPT session using Stream Operator overriding Macro database
When writing to two different databases using the Stream Operator -- i.e. the Working/Target database differs from the database used for Log/Error Tables and Macros -- you receive the following error in your session log:
TPTWR_3523 : [ERROR] Type:(Teradata DBS Error), Error: ()
The following error is in the TD_OPER trace file (set to TD_OPER_ALL):
**** 19:14:54 Instance 1: RDBMS error 3523: An owner referenced by user does not have INSERT WITH GRANT OPTION access to db2.MENU_ITEM_FIXED_PERIOD_TOTAL.
This is caused by insufficient permissions on the macro created (on the overridden Macro Database) which is trying to execute onto the Working Database where target data is written.
To resolve this issue, override the Macro database to be the same as the Working Database (Target Database)."
Or just GRANT INSERT ON target database or table TO macro database WITH GRANT OPTION.
I am facing the same issue using TPT Stream Operator, The error message is:
TPT10508: RDBMS error 5315: An owner referenced by user does not have INSERT WITH GRANT OPTION access to
I have given the required access rights but still unable to execute it, is there anything else I need to do? Please help