Page 2 of 2
Posted: Wed Mar 17, 2010 3:58 pm
by chulett
The other thing I would look at would be to follow the instructions as documented - create a role, assign the grants to the role and then the role to the user. That is not equivalent to direct assignment of grants to a user, btw. See if that 'fixes' things. If not, then I'll jump right in the same 'very odd problem indeed' boat next to Arnd.
Posted: Wed Mar 17, 2010 8:20 pm
by surajkumar
Oracle 11g
Datastage 7.5.2
Posted: Wed Mar 17, 2010 8:26 pm
by surajkumar
i have just hard coded the value NSO_REF .their is no parameter
i have tried what u said,created a test table and tried to access getting same issue
i am using .
Oracle 11g and Datastge 7.5.2
Posted: Wed Mar 17, 2010 10:32 pm
by chulett
You do know that 11g isn't "officially" supported, yes? Unless I've missed something lately. Regardless, have you raised this issue with your official support provider?
Posted: Thu Mar 18, 2010 6:26 am
by surajkumar
i tried with
Read method=user defined query like "select * from <Table>"
i can able to connect and view data
But not with read method=Table