Re: password for internal?

From: Alex News <alexr_at_mincom.com>
Date: 2000/08/03
Message-ID: <8mb1jf$5ta$1@sol.mincom.oz.au>#1/1

Hi,
You can't do that. Internal is login for OS athenticated users, i.e. you have to belong to a group
with ownership of the oracle instance. You can create a password file as well and the doco
is saying that this is how you change the sys and internal password. This is true for sys but
oracle will connect you to sys schema every time you connect as internal (it disregards the password).

Alex

"kev" <kevin.porter_at_fast.no> wrote in message news:397C5ED1.7CC8CCD9_at_fast.no...
> Hi,
>
> How do I make Oracle require a password when you log on as internal?
> I don't want to leave it password-less because then anyone can get in
> and do nasty things. I tried:
>
> alter user internal identified by passwd;
>
> but got this error:
>
> ORA-01918: user 'INTERNAL' does not exist
>
> So, how's it done?
>
> thanks,
>
> - Kev
>
Received on Thu Aug 03 2000 - 00:00:00 CDT