Re: OPS$ USer

> gomes wrote:
>
> Hallo....
>
> please help me...
>
> I have some trouble about create user By OPS$
>
> i have been create OPS$ User but i got some problem.
>
> if i logon with user OPS$ i have some error message like this :
>
> ORA-01004: default username feature not supported; logon denied
>
> why ....???
>
> Thanks alot.

You should never!!!!!!! create an id called 'OPS$'. It should always be something like ops$xxxxx where xxxxx is the system (e.g. Unix, VMS, Windows95, etc) login that you want a default oracle login for.

I use unix. My Unix id is kstahl. Therefore my Oracle default login in ops$kstahl.

To create a default login account, do it something like this:

create user ops$kstahl identified externally; Received on Tue Nov 09 1999 - 08:57:45 CST