Hi HomerJ,

The best way to manage users through automation or outside means is through the Use of The Site Administration API. You can find the information here within the guide for that API (this is for ALM version 12.5 but your specific version can also be found through the reference website and the principle is the same of all versions): https://alm-help.saas.hpe.com/en/12.50/api_refs/site_admin/webframe.html#topic3.html You can use this guide to get the syntax and the structure for creating the API calls to the Site Admin and can use this to add users, add users to groups, projects, etc.

As for using the Oracle product I can not find any information for the interface of that project with the ALM product (not to say it is not possible but that Microfocus/HP provides us no guidance or information on compatibility and if it is using standard REST architecture it should work I can only assume as ALM is utilizing the REST architecture).

The API referenced above and the REST APIs are the best ways to automate this functionality. I have not personally been aware of any clients using the automation of the USERS table as it is generally something that most are not changing much as once users are added most don't ever remove them from the list (to preserve the comments history) and generally aren't dealing in large user base changes that automation would benefit from, but as I say this is just my experience and not to say some clients aren't utilizing it that I am not aware of.

Hope this helps,
Dan