We have found by matching WF Oracle respository WF_MRUSERS to Active Directory that we have almost 100 users that are no longer active.

I've noticed that the Oracle tables use the CASCADE DELETE on the tables with foreign keys to WF_MRUSERS. I can easily write an Oracle DELETE statement to get rid of the inactive users, my question is if this is safe or do I have to go through the Web Interface? The Oracle part is pretty straight forward, but I do not know what WebFocus may be doing "under the covers" using the Web User Administration Console.

Any help appreciated, Thanks.

- Dave

This message has been edited. Last edited by: Kerry,

FYI, Dave already has a case opened regarding this issue.

Dave, if you hear an update/solution from the case, can you please keep us posted? Thank you in advance for sharing with all.

Cheers,

Kerry

Our WF Technical rep strongly suggests that we use the Administrative GUI rather than direct update to the backend repository. He says there are some folder names and other "stuff" in the background that need to be maintained via the GUI.

Dave,
You can safely do this with WebFOCUS Client web service calls if you wish.

Take a look at MREDeleteUser.

Web Services Manual

If you don't already program in Java, or .NET VB.net is pretty easy to pickup and Microsoft has Visual Basic Express 2010 for free.

You can do everything you need to do with the free version of Visual Basic Express.

Thank You dlogan.