Hi.

Anyone can guide me on this.

I have a legacy structure where i have 12000 clients. each client has
a password.

Table_Name = clients
Fields= Identificaction, Name, LastName, Password, Active

1) any idea about how can create users on LDAP based system ( openldap
or active directory ) based on this structure.
2) the solution must active o disable the client on LDAP system if the
Active field on oracle table it's true or false.


please advice me.

Aquiles.- wrote:
You are asking for a one week class not a couple of sentences
tossed at you in a usenet group.

Have your management get you the training or hire a consultant
that will train you as part of the engagement.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Fri, 14 Dec 2007 12:50:09 -0800 (PST), "Aquiles.-"
<aqcohen (AT) gmail (DOT) com> wrote:

Oracle has a product called Oracle Internet Directory. It is Oracle's
LDAP implementation and comes with Oracle Application Server.
Http://www.dizwell.com has a writeup on how to integrate Oracle
Internet Directory and use Mickeysofts Active Directory, instead of an
Oracle database.

--
Sybrand Bakker
Senior Oracle DBA

Aquiles.- wrote:
You can also look at Oracle Virtual Directory.
As the name says it's a Virtual LDAP that acts like a view on Active
Directory, Database Tables (with users) and provides an LDAP interface

cheers,
p.

On Dec 14, 3:50 pm, "Aquiles.-" <aqco... (AT) gmail (DOT) com> wrote:
Hi,

openldap has a well defined API. You should be able to extract your
data from your tables and build the ldif file(s) to populate your LDAP
schema. However, that assumes that the openldap infrastructure
(service, schema, object model, etc.) is already built. I can't tell
it that is true based on your question that asks how to create a user
based on it (Oracle), with the next one asking how to disable access
based on it. Aren't you doing a one time cutover from your current
table based setup to LDAP?

HTH,

Steve

On Dec 19, 4:13 am, "stevedhow... (AT) gmail (DOT) com" <stevedhow... (AT) gmail (DOT) com>
wrote:
OK thanks Steve.

Pedro, Sybrand i heard that using Oracle Virtual Directory each user
on the active directory it's a user on the database system. it's that
true? Is This Oracle Virtual Directory necesary if only want to
syncronice a table with client information to LDAP based system?

Thanks

Aquiles.- wrote:
That's not the point of a virtual directory.

Check details here:
http://www.oracle.com/technology/pro...vds/index.html
http://en.wikipedia.org/wiki/Virtual_directory

hope it helps,
pedro