Re: password for internal?

Hi ,

You have to check if your 'dba' group in unix groups is in small letters and not DBA and that you are dba to connect internal.

--Good luck :)

In article <8mb1jf$5ta$1_at_sol.mincom.oz.au>,   "Alex News" <alexr_at_mincom.com> wrote:
> 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
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 03 2000 - 00:00:00 CDT