I took a relatively simplistic approach -- I simply created a table in my Oracle database which contained a field that corresponded to each field in a UNIX password file. I then wrote a script to split the password file on each colon character and inserted the data into the Oracle database.
I did not modify the operating system to authenticate from the Oracle database, so on a regular basis I export the SQL-based password file out into a flat text file and re-construct the UNIX password file on the machines that need it. This allows me to make centralized changes to the SQL password database and have it flow through to all the other machines. (If someone knows how to get the operating system to authenticate directly from the Oracle database, let me know, it'll save me the step of exporting the SQL password data to a text file). I do all of this behind a firewall, of course, and you should too if you plan on it being secure. Hope that helps. John At 08:39 AM 10/5/01 +0800, you wrote: >john, > >I also want to migrate my users in the /etc/passwd UNIX >into ORACLE, but I got no idea how to do it. >Hope you can share your experience. > >Thank you. > > >Best Regards >Jaafar Sarim >SingNet === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.