Book a Demo

Author Topic: What privilege does EA need to reverse engineer Oracle 9i schemas?  (Read 5047 times)

Richard Freggi

  • EA User
  • **
  • Posts: 498
  • Karma: +18/-7
    • View Profile
So I got to connect with my Oracle dinosaur and the reverse engineer wizard lists the schemas directly, but when I click on 'Import schema' it hangs... I suspect it EA cannot read from the system views it needs to diwnload the DDL.

Can Sparxians share info on what user privilege is needed to reverse engineer, so I can complete the reverse engineer... thanks!

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: What privilege does EA need to reverse engineer Oracle 9i schemas?
« Reply #1 on: January 27, 2021, 02:34:12 am »
I would guess it's admin since you need to read the system table info.

q.

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: What privilege does EA need to reverse engineer Oracle 9i schemas?
« Reply #2 on: January 27, 2021, 06:06:17 am »
Qwerty is right you need admin to read table and relationship info
Happy to help
:)

Richard Freggi

  • EA User
  • **
  • Posts: 498
  • Karma: +18/-7
    • View Profile
Re: What privilege does EA need to reverse engineer Oracle 9i schemas?
« Reply #3 on: January 27, 2021, 01:00:35 pm »
Thank you all, was afraid so... Thanks!