Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Password protecting Internal

Re: Password protecting Internal

From: oracle <oracle_at_nightmare.com>
Date: 1997/01/27
Message-ID: <32EC37D6.6E1F@nightmare.com>#1/1

R. Wayne Linton wrote:
>
> Carl, Christianson wrote:
> >
> > I am looking at password protecting the connect internal statement from svrmgrl.
> > I am running Oracle 7.3 in AIX 4.1.4. How does one go about this?
>
> Carl, have a look at the ORAPWD utility. This creates a password file
> for internal and sys (and other userids as you see fit). You can have
> one for each instance or you can share this one password file across
> several instances. You create this file via the ORAPWD utility. In vms
> you set up an executive level logical for it so the system can find it; I
> don't know about AIX.
>
> Look in your "ORACLE7 Server and Tools Administrator's Guide", chapter 2.
>
> --
> R. Wayne Linton, I.S.P.
> Database & Systems Management
> Shell Canada Ltd.

You need to use a sql*net connection for this to work. If the user is logged "dba" group and not using TWO_TASK to connect it still will not prompt for the internal password even if you use orapwd. Received on Mon Jan 27 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US