Thursday 10 March 2022

e1local SQL access via reconfigureDB.exe

I have an interesting problem which requires elevated oracle permissions that I cannot get from my AWS RDS.  Quite specifically I want 

Honestly, why does it paste like that.

Anyways, I can work around it by running things on the local database on a thick client, but again - I need some hefty permissions.

So, goto e920\system\bin32 and run reconfigureDB.exe

You'll get this:


Now choose from enhanced encrtpyion to password and enter a secure password

Immediately you will be able to login locally (e1local) as sys with something like:

sqlplus sys/PassWord99 as sysdba

I run sqlplus from the bin location of e1local, therefore not really worried about tnsnames being configured incorrectly from a client.

All done, I can grant away now.  


as you can see I can also use SQLDeveloper (client app) with basic connection to e1local using the new username and password I created - and we can navigate this database.



Which is also handy if things are going wrong or you want a local database to test things.