Re: sqlplus and using the slash as login and password

No. Nothing new. I made it up. I was close though. Serves me right for being too quick. There are two params you can set.

First, there's OS_AUTHENT_PREFIX, which allows you to set the prefix of the Oracle account needed for OS authentication. If set to null, using "", the Oracle account name should match the OS account name. If not null, the Oracle account name should be the OS account name prefixed by the value of OS_AUTHENT_PREFIX. This parameter defaults to OPS$.

In either case, the Oracle account should be altered to IDENTIFIED EXTERNALLY.

Second, if you want to allow OS authentication over a network, there's the parameter REMOTE_OS_AUTHENT. That's what you'd set to true. Be careful with that though.

For more info, check out the administrator's guide.

Thanks for catching my mistake.

Yosi

Kenneth C Stahl wrote:

> Is that something new with Oracle 8? I use default logins on a 7.3.4 database
> and I don't have that parameter in my init.ora and it works just fine.
>
> Ken
>
> Yosi Greenfield wrote:
>
> > And set OS_AUTHENTICATION = TRUE in your init.ora.
> >
> > Yosi
> >
> > Kenneth C Stahl wrote:
> >
> > > You need to define an ops$name account in oracle where 'name' is the
> > > userid of the account that is running the script. Thus, if you log into
> > > unix with xyzzy then you need to define an account called ops$xyzzy in
> > > Oracle with "identified externally" and then make sure it has connect
> > > privileges.
> >
Received on Fri Jul 16 1999 - 14:53:44 CDT