Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8 and NT Authenication

Re: Oracle 8 and NT Authenication

From: William Lessard <wlessard_at_mediaone.net>
Date: Sun, 16 Aug 1998 14:10:19 -0700
Message-ID: <CWHB1.1078$EF3.7998880@cmnws01.we.mediaone.net>


Thanks... :)

Mujeeb_ur_Rehman_at_hotmail.com wrote in message <6r78k7$v2j$1_at_nnrp1.dejanews.com>...
>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 - 16:10:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US