How to Restore ARA user Permission ?

Document ID : KB000094210
Last Modified Date : 05/07/2018
Show Technical Document Details
Introduction:
By mistake I removed the permissions to the user ARA client 100 for the release automation. I have un-cheked in this section "User is Administrator"
How can I restore them? this section has now disappeared (Release Automation) 
User-added image
User-added image
Background:
The admin user was created in the initial step of the installation, you can follow this link for reference 
Instructions:
Step1
Check the ARA's log, or config file, look for system User
in the example below, user is 100/ARA/ARA
Connection - Name: UC4; System: AUTOMIC;
    CP: a101ap1c.ced.it:2217
    CP: a102ap1c.ced.it:2218
    System - User: 100/ARA/ARA; Client: 100.
        Queue trigger - Agent: WIN01; Login: LOGIN.WIN01.
        Connection strings:
            MainDatabase:Data Source=tcp:a101dp1c.ced.it,1433;Initial Catalog=ARA;User ID=AUTOMIC;Password=*****
            DB Versions: 800201709121; 800201709081; 800201708231; 800201708171; 800201708161; 800201708141; 800201708011; 800201707251; 800201707201; 800201707191;

Step2

 Run the below SQL statement against ARA database, It will help to bring you the admin previledge 
 
update usr set IsAdmin='1' where id in (select id from Member where Technicalname='100/ARA/ARA')