Skip to main content

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.

Be the first to reply!

Reply