Re: internal password in Solaris

David Novo wrote:

> How can I set the password to Internal in Oracle8 with Solaris
>
> David

Oracle8 Administrator's Guide
 Release 8.0
 A58397-01

Using an Authentication Password File

If you have determined that you need to use a password file to authenticate users performing database
administration, you must complete the steps outlined below. Each of these steps is explained in more

detail in the following sections of this chapter.

  1.Create the password file using the ORAPWD utility.

    ORAPWD FILE=filename PASSWORD=password ENTRIES=max_users

 Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE.

 Add users to the password file by using SQL to grant the appropriate privileges to each user who needs to perform database administration, as shown in the following examples.

    GRANT SYSDBA TO scott
    GRANT SYSOPER TO scott

The privilege SYSDBA permits the user to perform the same operations as OSDBA. Likewise, the privilege SYSOPER permits the user to perform the same operations as OSOPER.

 Privileged users should now be able to connect to the database by using a command similar to the one shown below.

    CONNECT scott/tiger_at_acct.hq.com AS SYSDBA Received on Wed Feb 24 1999 - 04:04:37 CST