Re: Oracle 8 and NT Authenication

Hi :)

Well u can create users in Oracle which are authenticated on OS level. Do as follows if u want users to connect to Oracle without supplying username/password

• Create a user account on NT server where your Database resides. let say u created account Mujeeb
• Now create an OPS$ account in the Oracle database as follows

  create user ops$mujeeb identified externaly   default tablespace <tablespace name> temporary tablespace <tablespace name>   quota unlimited on <tablespace name> ... ;

  grant create session to ops$mujeeb;

Give any further grants whatever is required for user to carry out his/her job. The thing that u have to remember is, the user name of NT and Oracle prefix with ops$ should be the same.

Now once the user logs on to your NT server successfuly and then tries to connect to the database, Oracle will not prompt him/her for the password.

Note : This user will not be able to connect to Oracle untill or unless he/she logon to the NT successfuly. This only applies to user for whom u have created ops$ account.

A simple way to make sure that users logon and get authenticated on the NT server is that u create a share on your NT server and let user map to that share. In the permisson for this share u include your users.

So once they connect to share NT will authenticate them and once this is done. Oracle will let your users connect.

Hope this help.

In article <r0wB1.1061$EF3.7716989_at_cmnws01.we.mediaone.net>,   "William Lessard" <wlessard_at_mediaone.net> wrote:
> I have a program that makes users log into a database. Is there anyway to
> use nt authenication for this instead?
> Any help is appreciated.
>
> Users are using win95.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Aug 16 1998 - 13:32:39 CDT