Re: Oracle/Windows NT user authentication ....

Hi,

You are looking for Operating System Authentication. Within the Oracle INIT.ORA parameter file, there is a parameter called OS_AUTHENT_PREFIX which defaults to the string "OPS$". This can be changed if required.

Now for a user with an NT account of "ADMIN" to connect to the Oracle Database, you just need to create an Oracle User called "OPS$ADMIN".

If the database is not on the same machine, then you also need to enable the parameter REMOTE_OS_AUTHENT, but before you do this, make sure you check out the security implications as talked about in the Oracle Manuals that talk about Operating System Authentication. REMOTE_OS_AUTHENT can be VERY dangerous.

Rgds
Andrew

vpenmatsa_at_hotmail.com wrote:

> Hi,
>
> I'm using Oracle 8.0.5 on Windows NT ,
>
> Is there anyway that I can use Windows NT users (IDs & passwords) to log on
> to Oracle without having their IDs stored in my Oracle database .
>
> Thanx .
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 30 1999 - 20:02:25 CST