Hi
I've created packages, they compile correctly etc. But I am getting an error when trying to execute from a vb application. The application user has execute writes on the packages, the package owner has the correct privileges granted directly to it. the packages execute correctly through sql plus and other tools with the same user/password as the vb app. BUT it wont work with the VB application, instead i get a "table does not exist" error.
The vb application only works if i give its user grants on the tables etc accessed by the packages, which we are trying to avoid in order to provide an extra layer of security.
I've checked for synonyms and most other errors but have had no luck. Has anyone any ideas as to what this could be?
The TAR we raised came back with unhelpful suggestions such as "are you connecting correctly?".
Platform: NT
Oracle 8i with visual basic 6
Thanks
JP
I've created packages, they compile correctly etc. But I am getting an error when trying to execute from a vb application. The application user has execute writes on the packages, the package owner has the correct privileges granted directly to it. the packages execute correctly through sql plus and other tools with the same user/password as the vb app. BUT it wont work with the VB application, instead i get a "table does not exist" error.
The vb application only works if i give its user grants on the tables etc accessed by the packages, which we are trying to avoid in order to provide an extra layer of security.
I've checked for synonyms and most other errors but have had no luck. Has anyone any ideas as to what this could be?
The TAR we raised came back with unhelpful suggestions such as "are you connecting correctly?".
Platform: NT
Oracle 8i with visual basic 6
Thanks
JP