on 10-29-2008 4:14 PM
Hello
We are planning to do a role cleanup and planning to delete roles from Access Enforcer.
I get the error "referred to by the request"
How can i bypass this and delete the role.
Thanks
Hi Prakash,
Since the role you are trying to delete has associations with a certain request , this means the tables having request details are referring to this role therefore from application , it will not let you delete the role .
You can directly execute following query at DB :
delete from SAP<SID>DB.virsa_AE_ROLDTLS;
Where SID is your SAP Instance name e.g F21/P40 etc.
Caution : 1.Take a back up the roles in this table before deleting .
2.Make sure that the Role mapping , Default roles , Role Reaffrim , functional area company approver , have not been configured , in case they are configured then you will have to delete enteries from that table as well .
Thnks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is also another way if your intention is just to remove the role from user selection during access request creation. Search for the role you want to "decommission" and just remove the system assignment in the role (PRD, QAS, etc) and the user should not be able to search and request for the role anymore.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.