I mistakenly deactivated admin group , now there is no user who is an admin to activate it again , is there any way I can do to activate the admin group again ?
Did you deactivated the Group? The only way i can think of is to directly update CMN_SEC_GROUPS tables to make it active
Yes the group is deactivated
select * from cmn_sec_groups where group_code = 'admin' ;
update cmn_sec_groups set is_active = 1 where group_code = 'admin'
change the group_code to your group name
Just wondering again...
Does any user have rights to read the group out with XOG and write it back again with active status?
Is the admin user still active and does admin have there rights to activate the group?
Thank you so much it did work fine
Thank you Sibusiso, ensure you keep a user with global rights so you dont run into this accidently.