1
Good afternoon!
I ask for your support, I have a strange problem. I have created a view on a certain Owner and use this view on a Crystal Reports. With my user (Seto the values in App.Config of my solution, which is in c#) I can generate the reports without problem, however, with the application user does not scroll. I requested the application user read Grant in the tables within the view and in the view itself.... If I run the PLSQL query with the application user it returns normal information, but if run through Crystal generates the following error:
Note: Personal, as I said, with my functional user normally, but the error occurs only with the application user. I believe I requested the correct Grant.
Thank you!
Tried with Owner.view on Crystal or create a public synonym for the view ?
– Motta
Good morning, Motta. Actually yes. I asked dba’s for a synonym of this view. I’m suspicious of the Crystal version. This is a legacy "rpt" of a VB that I am automating in c#, so maybe there is a versioning problem since it must have been done in version 9 and I am using version 11. I will see this (I touched it yesterday) and put it here... But if you have another idea, please... : D
– claudio vieira