Is it possible to restore Admin Role?

A full ERP system - moved to GitHub. See full description for details.

Brought to you by: kthiemann, mar_cal_westf, mjmckay, nwessel, and 2 others

Is it possible to restore Admin Role?

Forum: Bazaar Open Discussion

Creator: Anonymous

Created: 2009-08-11

Updated: 2013-03-08

Anonymous - 2009-08-11

I have corrupted my admin role to the point that i have no menu or way to access anything under my Admin role. i can log in under a regular user and system administrator but no other role has the ability to create or modify roles for the client/organization. Is there any way to just create a new Admin role or fix the old one?

Thank you for your help!
-Derik

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- juniorionut - 2009-08-12
  
  Derik, do the following, but be advised that this, in my opinion is only an "emercency" procedure.
  
  SELECT AD_Role_ID from AD_Role WHERE Name='YourAdminRoleName';
  
  Change in the following statements the 'YourAdminRole_ID' with the id that you got above.
  
  update ad_window_access set IsActive='Y',IsReadWrite='Y' where AD_ROLE_ID=YourAdminRole_ID;
  update ad_process_access set IsActive='Y',IsReadWrite='Y' where AD_ROLE_ID=YourAdminRole_ID;
  update ad_form_access set IsActive='Y',IsReadWrite='Y' where AD_ROLE_ID=YourAdminRole_ID;
  update ad_workflow_access set IsActive='Y',IsReadWrite='Y' where AD_ROLE_ID=YourAdminRole_ID;
  Best regards,
  Junior
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.