Hello,
We have a customer request to remove a user from a company.
The point is that the finance user can be used in 34 other Logical Unit (V10)
The list of those Logical units can be found by executing this SQL Statment :
SELECT lu_name, view_name, col_name, parent_keys, option_name, option_arg1
FROM reference_sys_tab
WHERE ref_name = 'UserFinance'
AND option_name IN ('RESTRICTED','CUSTOM','CUSTOMLIST','CASCADE')
So my questions are :
1/ Has someone already created a script or made a Modification to remove a finance user from a company ?
2/ If you faced the same request, how did you solve it ?
Thank you.