Book a Demo

Author Topic: Import db schema from Oracle db  (Read 2769 times)

MarcusRool

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Import db schema from Oracle db
« on: June 28, 2017, 09:19:06 pm »
I'm trying to import db schema to sparx via odbc and I have a user without admin roles. I did it, but i haven't all diagrams that can be created. It has access only on certain tables for monitoring database performance.

What minimal privileges my user should have to do this task? I know that I can retrieve user's schema, but I want to retrieve all schemas.

I hope there is no need for dba role or access to select all tables and dictionaries, because data in some tables is secret, and i want to see just a structure.