Delete Authorizations which have no profiles

Question: Hello Everyone,

I have situation where there are authorizations existing in the system , but do not have any role/profile associated with it , These auths. are obselete and have to be deleted (to decrease the size of UST12 table), I am manually checking the auths related to each obj. and deleting them via SU03 , is there a better way of deleting these auths. ?

Thanks,

Answer:
You can try report RSAUTHXPRA or run function module SUSR_SYNC_USER_TABLES with tabletype = 'X'.
This will clean up the USTxx tables but will not get rid of the TRUE orphaned authorizations that SAP creates in PFCG.

I though I saw a report that does this but it may be a 4.7 option.

Answer:
Thanks John ,

But this program is not deleting any entries .

The situation I have is authorizations were created manually in some older version of SAP and the system was upgraded to 4.7 , now the authorizations exists in the system , but are not related to any profile/role/activitygroups and are not being used anywhere, is there a program or method to delete these authorizations without having to delete each one from su03.


Thanks,

Answer:
Not delivered by SAP.
Copyright ?2007 - 2008 www.jt77.com