Deletion of Roles in AE

[Former Member]

Hi Everyone,

We are using 5.2 and trying to remove all the roles imported from our test environment. Though, we are having an issue where we are only limited to deleting the roles via the search function that only allows 15 deletions per submit. Is there a way we can delete the entire table/db of roles in AE?

Thanks,

Jerri

[former_member366047 · Accepted solution]

Jerri-

You can ask your DB or Basis person to delete the contents of the Role table in RE using a SQL delete script/statement. I do not know the table name offhand, but will try to find it for you.

Ankur

[Former Member · Accepted solution]

Hi Jerri.

Be careful with the deletion, you do not delete any roles you have used in your workflows, as this will cause inconstancies in the tables.

As Ankur has said the only way to do a mass delete is at the database level

Kind Regards,

Terry Carter

SAP Security Consultant

su53solutions

[koehntopp]

Jerri,

please open a message under GRC-SAC-SAE, and aks support for a skript.

Frank.