Mass role deletion in CUP 5.3

[Former Member]

Hi all,

in our CUP 5.3 system someone has unintendedly imported all roles and profiles from the backend system (about 4000 roles).

How can we delete those roles from CUP without having to delete it from the frontend, which will take ages.

Is there any way or database script to safely remove the roles?

They can be determined by either role approver or last reaffirm date.

Thanks

Daniela

[koehntopp]

That's why I tell my customers

"Whatever you want to do in Role Import - ALWAYS klick on "from file" first. No Exceptions. Never!"

You're out of luck, there is no delete script. You can ask support for the DB ER document, but you'll have to do DB manipulations on your own risk, I'm afraid...

Frank.

[Former Member]

Hi Frank,

I was afraid of this answer...

That's what happens if the consultant is not the only one with AE_ADMIN anymore.

Thanks anyway,

Daniela