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
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