Re: changing the 'ops$' prefix

Johan,

Do the following.

Set the following parameters in the init.ora and bounce the database.

1. os_authent_prefix="" (This removes the OPS$ prefix)
2. remote_os_authent=true ( This allows OPS$ Logins to be turned on ie. sqlplus /).

Cheers,

Roger

"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message news:sigq87spo141_at_corp.supernews.com...
> "Johan den Boer" <jj.den.boer_at_hccnet.nl> wrote in message
> news:39277112.C7660794_at_hccnet.nl...
> > Hi,
> >
> > Does anyone know where I can change the ops prefix
> > for users to logon directly with sqlplus.
> >
> > regards
> >
> > Johan den Boer
> > e-mail : jj.den.boer_at_hccnet.nl
>
> IIRC, it's the "set prompt" option. Example:
>
> SQLPLUS> set prompt myprompt
>
> myprompt>
>
> I think you can change it in your init.ora file so that way it gets set
 when
> the DB is started (or maybe when the user logs on? not sure...). I'm not
 a
> DBA, so I might be wrong, but give it a shot.
>
> -Matt
>
>
Received on Mon May 22 2000 - 00:00:00 CEST