Re: OS Authentification

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 28 May 2002 09:47:05 +1000
Message-ID: <8CzI8.15$xn.23@news.oracle.com>

Because server manager is a (practically obsolete) tool used to perform administrative actions on the database.

And what you are setting up here is not really O/S authentication at all, in the usual sense of 'using the fact I logged on to the operating system to allow me to access Oracle as a privileged user'. Instead, you are simply getting Oracle to check the O/S logon for a match on *ordinary*, non-privileged users, previously created in the data dictionary.

So, Mr. Test is not a privileged user. Therefore, Server Manager wouldn't let him log on in a month of Sundays, whatever you did.

Try doing the "connect /" with SQL* Plus, on the other hand, and you will probably be OK.

That said, I see no evidence that you have granted 'create session' privilege to your test user, and without that, you're doomed whichever way you try it.

Regards
HJR "Alain" <alainthiery_at_vnumail.com> wrote in message news:3cf2ab89$0$249$626a54ce_at_news.free.fr...
> I try to authentificate oracle user by the operating system (windows 2000
> and NT 4) but i can't succed
>
> - on oracle 8.1.7 - i have made an account TEST identified Externaly
> - i have create a user TEST on Windows
>
> os_authent_prefix = ""
>
> but when i connect to svrmgrl by a connect /
> it say me logon denied
>
> why
>
> ALAN
>
>
Received on Mon May 27 2002 - 18:47:05 CDT