Re: How to login to Oracle using Active Directory Account

From: Frank van Bortel <fbortel_at_home.nl>
Date: Tue, 15 Jun 2010 21:31:49 +0200
Message-ID: <64c9c$4c17d526$524ba3af$31518_at_cache6.tilbu1.nb.home.nl>

On 06/11/2010 01:42 PM, kkausu wrote:
> Hi Rob,
>
> I work in a school. In the last years we created usersaccounts for the
> students in our Oracle DB.
> Now we have a Active Directory (Windows Server 2008) and a Oracle
> Server on a Windows 2008 Server.
> I don't want to create account in AD and Oracle. Is there a easy way
> to configure Oracle to use the AD for authentication?
> Some software-products can use LDAP or RADIUS to authenticate a user
> on AD before access the software.
>
> I read some documents about oracle SSO, OVD and OIM but I think I
> don't need this big products?! In postgres for example you to
> configure a few lines.
>
> I don't wont to administrate the user in 2 directorys (AD and oracle).
> The user should login in oracle and oracle should ask the AD - ready.
>
> Is this posible???
>
> Thanks
> kati
>

Possible - yes.
Easy? Define difficult ;)
Cheap: Hell no! You need to licence the Advanced Networking Option (about 8k per CPU - contact your sales rep.)

Not sure why you want Oracle - if for SQL study, you're stuck. Did you take a look at Apex? It's free (but "limited" on CPU and storage), and easy to incorporate with nay LDAP, inlcuding AD

-- 

Regards,

Frank van Bortel

Received on Tue Jun 15 2010 - 14:31:49 CDT