No longer have a User with admin rights , PPM v 15.5.1

[Sibusiso Nhleko]

Hi

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 ?

[Suman Pramanik]

Did you deactivated the Group? The only way i can think of is to directly update CMN_SEC_GROUPS tables to make it active

[Sibusiso Nhleko]

Yes the group is deactivated

[Suman Pramanik]

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

[Deactivated User]

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?

[Sibusiso Nhleko]

Thank you so much it did work fine

[Suman Pramanik]

Thank you Sibusiso, ensure you keep a user with global rights so you dont run into this accidently.