Please anyone tell me how to create DBA user from ORACLE Application express(http://127.0.0.1:8080/apex/apex_admin)?
I installed Oracle 11gR2 XE on windows 8.1 PC and I am able to login to Oracle APEX (above link) with username: "ADMIN" and password used during installation. but I can't use same username/password to login to "Oracle SQL Command Line". I am trying to connect with command
All other solutions suggests a command "CREATE USER....." but I don't know where to write that command without connecting SQL Command line. I am missing a simple step somewhere. please help me.
My question is exactly opposite of this question. User with dba privs can't login to APEX, but can from SQL*Plus
Where I can login to Oracle APEX web interface and create new workspace, Schemas, Users but I am not able to login to SQL Command line to create Database objects.