Re: NT Database Auth...

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 - 01:34:01 CST