Re: internal and sys passwords

From: David Russell <user_at_msn.com>
Date: 1997/12/02
Message-ID: <01bcff62$31a05400$f15395c1@thor>#1/1

When you connect as internal you are connecting to the SYS schema and the SYS password is setup as part of create database to be change_on_install. If you do not have remote_login_passwordfile set in the initxxx.ora then you will never need to enter a password when connecting as internal and you will not be able to connect as internal on a client / server connection.

I would recommend reading the Server Administrators Guide Chapter 1 as it covers password files and connecting as SYSDBA (another way to connect to the SYS schema without logging on as SYS but remotely). Remember that with remote_login_passwordfile=exclusive that SYS and internal's password are tried together while the database in open.

In Oracle 8 logging on as internal/sys is effectivly discontinued, although by DEFAULT this is not currently the case. To move forward to the new security available in Oracle 8 set O7_DICTIONARY_ACCESSIBILITY=FALSE to protect against anyone logging on as SYS without SYSDBA.

Regards
David Russell Received on Tue Dec 02 1997 - 00:00:00 CST