Mass delete Data access profiles

[aditya_ponnala]

Hi

I am able to delete one Data access profile (DAP) at a time using Webadmin.
However I am not able to delete more than one DAP at a given time from the same webadmin. A custom user management tool that is available for download on internet doesn't have option to delete DAP's.

Struck with the only of deleting DAP's though web admin, I tried and tried again to see system is timing out to delete more than one DAP at a time.

Login SM21 says:In the standard system there is no timeout for RFC servers. When the first remote function call is made, the RFC is connected and logged on to. and when the RFC connection is closed, the RFC server is deleted. You can activate an explicit timeout for RFC servers for an existing RFC connection using the function module. TH_SET_AUTO_LOGOUT.  If within the time specified no further RFC calls are made,RFC server is deleted. If the RFC client then sends a further call to the server, this is sent back with an error code.

[lucas_costa3]

Take a look at class: CL_UJE_PROFILE_MEMACCESS methods: DELETE_MATRIX_MBR_PROFILES and DELETE_MBR_PROFILES

Cheers,

Lucas

[former_member186338]

May be some abap? Based on the code in BPC Mass User Management Tool?

[aditya_ponnala]

Thank you for the response Vadim. I found FM: UJE_API_DELETE_PROFILE and it deletes the entry from table: UJE_PROFILE_AGR. I can ask the developer to develop a program using this; but I am not sure how comprehensive it is and how risky that is. I looked at the program and it is using API's for create and update DAP's and doesn't have delete DAP's code anywhere.

[former_member186338]

I think that UJE_API_DELETE_PROFILE is the right way...

But one question - how many data access profiles you want to delete?

[aditya_ponnala]

~3000 out of 6,700. It is taking too much time to assign a data access profiles to a user and we think that is because of these many data access profiles. Hence want to delete obsolete/old ones.

[former_member186338]

6,700 data access profiles? Looks like something wrong with security...

[aditya_ponnala]

We know and that is what we are trying to address by deleting these obsolete DAP's. We will bring them down to 400.