Clarity PPM1

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  No longer have a User with admin rights , PPM v 15.5.1

    Posted 05-22-2019 11:31 AM

    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 ?



  • 2.  Re: No longer have a User with admin rights , PPM v 15.5.1

    Posted 05-22-2019 11:36 AM

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



  • 3.  Re: No longer have a User with admin rights , PPM v 15.5.1

    Posted 05-22-2019 11:45 AM

    Yes the group is deactivated



  • 4.  Re: No longer have a User with admin rights , PPM v 15.5.1
    Best Answer

    Posted 05-22-2019 11:50 AM

    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



  • 5.  Re: No longer have a User with admin rights , PPM v 15.5.1

    Posted 05-22-2019 12:35 PM

    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?



  • 6.  Re: No longer have a User with admin rights , PPM v 15.5.1

    Posted 05-23-2019 04:16 AM

    Thank you so much it did work fine



  • 7.  Re: No longer have a User with admin rights , PPM v 15.5.1

    Posted 05-23-2019 05:39 AM

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