Posted: Wed Apr 11, 2018 4:41 am Post subject: IIB 10 Maps - Working with Oracle Synonyms
Newbie
Joined: 29 Jan 2018 Posts: 2
Hi,
We have IIB+ToolKit 10.0.0.9, and using Oracle 11 Thin Driver to connect to DB inside maps.
I manage to successfully create table selects, inserts and Stored Procedures statements from within maps when I use the owner schema of the objects.
When I try to create a select statement of a synonym table, the mapper doesn't recognise the synonym objects.
Notes:
* When polling database objects using the Database Definition project, I check the "Synonym" object as well as other objects
* When creating the same objects with their owner schema - it works well, but I can not use the owner schema in other maps for security reasons
* When using SQL Navigator, I succeed executing DESCRIBE and SELECT statements for the synonyms using the non-owner schema
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum