Auto Creation of Users
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-10-2008 08:33 AM
Hi
I have a table in the DB called EMPLOYEE. From this, I want to automatically create new users in the SYS_USER table.
So, how can I maintain SYS_USER (insert update delete) based on changes in EMPLOYEE? I suppose it will have to be some kind of scheduled import job.
I hear that Business Rules is not the way to go.
Cheers
Dave
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-29-2008 05:09 PM
While it's clear what you are trying to do (after reading through the posts), it's not clear the business requirement for not working with the sys_user table directly and dropping the EMPLOYEE table concept.
Some insight as to why you're not just working with the sys_user table may help pave the way to the correct solution.
Writing a script that runs daily will be inefficient at best, and unreasonable (system resources) at worst - depending on the size of the user base and the strategy used.
If exclusively using the sys_user table is not an option, then I would recommend redesigning the EMPLOYEE table to use reference fields pointing to the sys_user table. Then have whatever process that populates (insert update delete) the EMPLOYEE table also work on the sys_user table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-31-2008 02:29 AM
Ok, thanks guys. I'll give the import sets a try when I'm back in the New Year.