Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: NT Database Auth...
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?
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 - 14:24:05 CST
![]() |
![]() |