Generate ER Diagram with view permissions

Posted on

Question :

Currently my environment that I’m working with is using Oracle DB 12 and I have been granted view permission only.

The issue is that the ER diagram that is given to me is not complete and sometimes retrieving data from different tables can be a challenge and time-consuming.

Therefore, is there any easier way that I could generate the full ER diagram myself or at least the relations with the current permissions I have?

Answer :

I used SchemaSpy and it worked flawlessly.

Leave a Reply

Your email address will not be published. Required fields are marked *