Re: Changing 'Internal''s password

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/09/03
Message-ID: <340E1090.34AB@postoffice.worldnet.att.net>#1/1

You could try using Oracle's password file authentication method.

Main steps are:

Create a password file using the ORAPWD utility provided by Oracle:

ORAPWD FILE=<file_name> PASSWORD=<password> [ENTRIES=nn]

<password> is the new password to be used by SYS and INTERNAL

ENTRIES is the only optional parameter. nn is an integer representing the _maximum_ number of users (other than SYS and INTERNAL) who will have SYSOPER and SYSDBA privileges.

2. Set the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE or SHARED (default is NONE, i.e. ORACLE will not use a password file as a means to authenticate users with superprivileges).

EXCLUSIVE means that the password file you created in Step 1 will be used by only one database. However, you will be able to add users other than SYS and INTERNAL to the password file by granting them SYSDBA and/or SYSOPER privileges. SHARED is the opposite: multiple databases, SYS and INTERNAL only as superusers.

You can find a more detailed discussion of this topic in "ORACLE7 Server Administrator" manual under "Database Administrator Authentication" (this is for Oracle7 7.3.3.0.0).

Hope this helps.

Michael Serbanescu

Kelly wrote:
>
> Hello all!
> I have just installed Oracle 8, and considering I am a newbie, I'm happy I was
> able to get things up and running so quickly. However, I have run into a
> problem....I am going through and changing all of the important user/admin
> passwords (SYS, SYSTEM...etc.). However, when I tried to change the user
> INTERNAL which has the password set to ORACLE on install, I get an error
> message saying INTERNAL isn't a user.
>
> Can someone tell me what I need to do here, the ALTER USER won't work with
> INTERNAL.
>
> TIA!!
>
> Kelly
> kgrigg_at_acxiom.com
>
> ps. please CC by mail too...our newsfeed is not reliable here....
>
> "If you've had half as much fun as me...
> ....Then I've had twice as much fun as you!!"
>
> kgrigg_at_acxiom.com
> cayenne_at_cei.net
>
> Visit my Website at: http://www.cei.net/~cayenne/index.html
Received on Wed Sep 03 1997 - 00:00:00 CDT