Re: NT Database Auth...

"Alex Fern." <aminzade_at_msn.com> wrote in message news:#VAyS8xgAHA.176_at_cpmsnbbsa09...
> I have multiple Oracle servers and I've created the local group of ORA_SID
> on each one, set the sqlnet.auth to NTS and made sure my password file
 param
> under initSID.ora is not shared but is set to NONE.
> My dillema is that it this scenario works on all o my 8i servers but not
 on
> my 7.xx.
> Is the 7.xx config for OS Auth dufferent from 8i? Is there anyway that
> someone can permenantly disable this feature in Oracle?

I'm not aware of it having changed since 7.xx, but since I only really know 8.0 onwards, I'm not qualified to sound even vaguely authoratitive on that. All that you have done so far sounds exactly right, so perhaps we are indeed looking at version problems.

Perhaps David or Sybrand can proffer further advice?

Regards
HJR
>
> Thanks
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3a693f47_at_news.iprimus.com.au...
> > ORA_DBA should be OK, and is designed for O/S Users to be authenticated
 on
> > all databases running on the one server. But you could try the same
> > technique with ORA_sid_DBA and see if you have better results. That's
> > designed to allow different O/S Users to be authenticated on different
> > databases, and is certainly the method recommended by the training
 materials
> > in the first instance. See if you can get the SID-specific version
 working
> > first. If it does, then it means that something else will need to be
 done
> > to enable cross-SID authentication, and I can't think what off the top
 of
 my
> > head. I suspect a visit to the registry may be in order, but let's not
 go
> > there until we have to, eh?!
> >
> > Just make sure that whatever groups you create really are local
> > groups -local to the Server hosting the database(s). Also make sure
> > (obviously) you really are logged on to the Server with the User Account
> > you've added into the local group.
> >
> > The comment about "on one server...and on the other" makes me think
 you've
> > possibly set up a DOMAIN group, and that won't work. If you've two
 servers,
> > you'll be creating two LOCAL groups, and logging onto each of the
 servers
> > directly, as a local User.
> >
> > Regards
> > HJR
> >
> >
> > "Alex Fern." <aminzade_at_msn.com> wrote in message
> > news:#LDPmkqgAHA.176_at_cpmsnbbsa09...
> > > Do you guys happen to know how can I setup Oracle8i on NT4 to use my
 nt
> > > authentication for sysdba.
> > > I have created a local group called ORA_DBA added my uid to the local
 group.
> > > I've also set the password file parameter in init.ora to NONE but when
 I
 am
> > > trying to login on the sqlplus prompt as:
> > > sqlplus /nolog
> > > connect / as sysdba
> > > I either get access denied on one server and on the other I get your
 do
 not
> > > have enough priviligaes.
> > >
> > > I greatly appreciate any help or refrence that you can offer me
> > > Thanks
> > > Alex
> > >
> > >
> >
> >
>
>
Received on Sat Jan 20 2001 - 15:43:28 CST