Sites assign to users

Our admin user created few sites in our systems (Agile 9.3.5), and then he built criteria and other administration based on these sites.
Unfortunately we removed by mistake some of these sites from ALL users (including the admin user), so currently no one  is privileged to discover these sites or re-assign them to other users in administration. It seems to be a dead-lock.
Can anyone advise how to resolve it (besides creating new sites and redefine everything again)? Maybe someone know how to assign the site to admin user through SQL?

Thanks

No Files Were Attached
Add Comment
1 Answer(s)

Hello Tal,

Below is the query to find out the sites assigned to a particular user, you need to modify it according to your needs to update the table

Swagoto Agile User Answered on June 13, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.