?
Solved

Accessing Active Directory from Oracle Forms (is it possible?)

Posted on 2004-09-09
3
Medium Priority
?
761 Views
Last Modified: 2011-10-03
I am creating a maintenance form to allow the Help Desk to create new users in the Oracle database.  I am wondering if I can create something in Oracle forms that would populate a list  with all the users in the Active Directory on our network.  Then select a username from that list.

Is this possible?  If so can you give me some direction on how to do it.
0
Comment
Question by:Intern
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
seazodiac earned 2000 total points
ID: 12022081
it's possible but it's a stretch. I see where you are going...

I think you can do this, theoretically,

configure MS arctive directory server to store its repository to Oracle database ( i have doubt for the feasibility of doing this, if doable, then rest of the steps are easier).
then your Oracle forms can have a LOV of users created based on Oracle tables.



the part that I don't understand is that HELP desk should be much better of managing user directly using MS active directory itself. rather than going through Oracle forms...it's also struck me as a huge surprise that you want to combine Oracle form , Oracle database with MS active directory.


it's easier to use .NET or VB or ASP to come up with the similar solution for managing users...they got better interface with AD...
0
 
LVL 1

Author Comment

by:Intern
ID: 12027223
This was just a "It would be cool" thought.  I just wanted the help desk to be able to select a name from the active directory and insert as an Oracle user.  The only reason for this is that I wanted to make it so a user did not have 2 different logins due to a typing error.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12028415
you can do that in VB or ASP through the web just as the same.

don't bother to do it in Oracle form. it's too complicated and overkill.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question