Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Password protecting Internal
Steve Holdoway wrote:
>
> On Mon, 27 Jan 1997 00:06:30 -0500, oracle <oracle_at_nightmare.com>
> wrote:
>
> >R. Wayne Linton wrote:
> >>
[snipped]
> >> 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.
[snipped]
> >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.
>
> I thought that if you set REMOTE_OS_AUTHENT to true in init.ora, then
> the above is not true. Mind you, I haven't checked!
>
> Cheers,
>
> Steve
This is mostly true. I think you would need to do the following:
alter database rename file 'oldfile' to 'newfile' Received on Mon Jan 27 1997 - 00:00:00 CST