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

Home -> Community -> Usenet -> c.d.o.server -> Re: authenticate DB users against Windows Server

Re: authenticate DB users against Windows Server

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 10 Mar 2006 07:58:13 -0500
Message-ID: <bamdnV-i0Ld76ozZnZ2dnUVZ_sidnZ2d@comcast.com>

"Cris Carampa" <cris119_at_operamail.com> wrote in message news:441138ea$0$29115$5fc30a8_at_news.tiscali.it... Good morning.

Scenario: Oracle DB Server 10.1 and Oracle AS 9.0.4 running on two different SUSE Linux SLES8 boxes.

We are going to deploy an Oracle Forms app with this platform. Since our customer bought the Forms & Reports version only, there's no Single-Sign-On so we use DB accounts to authenticate users.

Our customer asked us if it's possible to synchronize passwords with their Windows Server.

IIUC, this would require the creation of IDENTIFIED GLOBALLY users, but since they bought the Standard Edition they miss the "Enterprise User Security" feature so this solution is not possible with their configuration.

Is this correct?

Thank you. Kind regards,

-- 
Cris Carampa (spamto:cris119_at_operamail.com)

potevo chiedere come si chiama il vostro cane
il mio è un po' di tempo che si chiama Libero



nope... just identified externally:

on my lowly XP laptop with 10G Express:

SQL> create user "ENQUERY001\MCS" identified externally;

User created.

SQL> grant connect to "ENQUERY001\MCS";

Grant succeeded.

SQL> connect /
Connected.

SQL> show user
USER is "ENQUERY001\MCS"

++ mcs 
Received on Fri Mar 10 2006 - 06:58:13 CST

Original text of this message

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