Re: Everyone can log on as sysdba on oracle 8i??????

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:28tiku8sdsbfqr599s83j11bigj31q6ks5_at_4ax.com...
> On Thu, 1 Aug 2002 11:07:10 +0100, "Niall Litchfield"
> <n-litchfield_at_audit-commission.gov.uk> wrote:
>
> >You can change this behaviour by modifying the value of the init.ora
> >parameter remote_login_password_file and bouncing the database if you
wish.
> >
>
> I don't think this is true, neither for Unix nor for NT. Changing
> remote_login_passwordfile doesn't disable O/S authentication, it only
> governs which users have SYSDBA privs. 'internal' *always* has SYSDBA
> privs and whether you need a password for internal is not determined
> by remote_login_passwordfile.
>

Um but didn't the OP say that he could connect all his Oracle users 'as sysdba' without granting them the sysdba privilege. I don't see how else he could do this.

As always I may be wrong.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************