hi all, when I try to login on the isqplus login screen providing sys as user and the respective password I get: ORA-28009: connection to sys should be as sysdba or sysoper
I tried "sys as sysdba" + password and stuff like that... nothing worked..can somebody tell the oracle-newbie that I am how to pass this barrier called login screen ? I thank you so much !
Joined: Feb 18, 2003
Yes, I ran into this as well. It is a security issue with oracle. They do not allow you to log into the database as user sys from over the web. The solution is very easy though. Create a different user for yourself and give yourself the dba role permission.
Create user you identified by youpassword Grant dba to you