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.
No comments:
Post a Comment