Re: What is exactly the INTERNAL login? How to protect it?

Pedro Pimentel Figueiredo wrote:
>
> How do you restrict the INTERNAL login? Is it a user or a special type
> of login?
>

The internal login can be considered to be a special administrative user used for database administration (although it is essentailly the same as sys) and is controlled at the operating system level. Therefore only OS users in the same group (if Unix) as the original Oracle owner will be able to connect internal.
If you wish to allow other users internal access you can set a password by using the orapwd utility to create a file $ORACLE_HOME/dbs/orapw<$ORACLE_SID> and also set remote_login_passwordfile=exclusive
in the init.ora file.
Note that the password should be set the same as SYS's as it gets changed automatically when the SYS password is changed.

Hope this helps,

Ian Received on Thu Oct 02 1997 - 00:00:00 CDT