Skip to Content (Press Enter)
OutSystems.com
Personal Edition
Community
Support
Training
Training
Online Training
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Jobs
Ideas
Members
Mentorship
User Groups
Platform
Platform
ODC
O11
Search in OutSystems
Log in
Get Started
Back to Forums
Venkatesh Gude
63
Views
3
Comments
Can we use synonyms present in Oracle Database in Extension
Question
HEllo every one,
I want to create Oracle extension in outsystems application but the tables are under synonyms in Oracle database. Can anyone share your ideas is it possible to use synonyms in extension or not?
Thanks,
Venkatesh Gude.
João Pedro Abreu
Staff
I think you won't be able to import the tables as synonyms in Integration Studio, but you can import them using their original names, and then change the "Table or View name" to the synonym.
That being said, I can't imagine a reason why you would want to use the synnym in an extension.
Venkatesh Gude
Hi Joao,
Actually I am trying to create extension in integration studio, due to some security concerns business was unable to provide owner credentials of tables present in Oracle database instead they have provided me credentails of user who have read only access on those tables(we can query tables but those are not physically present in list of tables as provided in above screen) . Hence we are trying to use synonyms for those tables, Kindly help me in this situation to create extension.
J.
Â
MVP
afaik it's possible as long as you have enough rights on that schema.
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
See the full guidelines
 Loading...