Re: Connecting as SYSDBA/Normal

On Sun, 28 Jul 2002 23:50:24 +0200, "Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote:

>There is a lot of question people asking why they cannot connect as
>SYSDBA. There is really opposite question; I can connect SYS as SYSDBA
>but not as Normal. Every time I try start SQL*Plus as SYS as Normal I
>get the error message telling me that I'm not allowed to connect on DB
>as SYS without SYSDBA privilege! What's going on here?
>
>(O9i)

This has changed in 9i. SYS has become a special account, and you always need to use the SYSDBA privilege. This has been posted several times in the newsgroup, and of course it is in the release notes. I still can't understand why so many people here use the newsgroup as their first resort, instead of trying to resolve their own questions. Apparently those people belief members of the newsgroup should read the docs on their behalf.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Jul 28 2002 - 17:17:38 CDT