Book a Demo

Author Topic: Creating an Oracle Users Synonyms  (Read 2212 times)

hooch

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Creating an Oracle Users Synonyms
« on: June 30, 2008, 10:21:07 pm »
I am using EA 7.1.830 to create some datamodels for use in Oracle 10.2.0.3.  I'd like to use EA to look after all database objects for DDL generation (Not including tablespace or user definition).

In my database I have some users which are created only for security purposes, the only objects these users own are synonyms - which I would like to persist in EA and then use to generate the DDL.

I understand the use of 'Tagged Values' but cannot seem to find a way of creating a placeholder or similar to store synonyms.

Any ideas?  
« Last Edit: June 30, 2008, 10:21:49 pm by hooch »