Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8 and NT Authenication
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
![]() |
![]() |