Re: sys and system in 9i

Hi!

Yep, starting from 9.2 sys connections have to be as sysdba or sysoper. In 9.0 I believe sys account had the old behaviour. I don't know the exact reason, but maybe Oracle just wanted to simplify it's administrative accounts. So sys is always the most powerful user now, others might be, if granted sysdba (or sysoper) privilege.

So, try connect sys/password as sysdba or sys/password_at_alias as sysdba.

Tanel.

"Ed Wong" <ewong_at_mail.com> wrote in message news:a5ae1554.0307041427.1ae6d623_at_posting.google.com...
> I've migrated an instance from 8.1.7 to 9.2.0. After the migration, I
> can connect to system by connection string "system/password_at_tnsnames"
> but can't do that as sys. I got an error ORA-28009: connection to sys
> should be as sysdba or sysoper. Is it a normal behavior?
>
> If I need to do "connect / as sysdba" instead of connecting
> sys/password, why oracle doesn't make "system" account the same way?
>
> Thanks,
> ewong
Received on Sat Jul 05 2003 - 10:26:28 CDT