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 !
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
then logon thought isqlplus with this user.
I am using oracle 10g when I ran into this issue.
Jeremy Wilson
I am not young enough to know everything. - Oscar Wilde This tiny ad thinks it knows more than Oscar: