Re: Connecting as SYSDBA/Normal

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 29 Jul 2002 21:28:29 +0100
Message-ID: <3d462cb6_3@mk-nntp-1.news.uk.worldonline.com>

"Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message news:ai1p0r$fer6$2_at_as201.hinet.hr...
> 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)
> --
>
> Stjepan Brbot
>
>
>

O7_DICTIONARY_ACCESSIBILITY has (sensibly IMHO) been set in 9i to FALSE as the default, whereas in 8i the default was TRUE.

You can vary it in either case, if you really must.

Paul Received on Mon Jul 29 2002 - 15:28:29 CDT