Hello,
what is wrong in the query :
update cwd_user set active='T' where user_name='Username';
?
i need a query to set all user which are acitve to the status activ. and other userers to the status not activ.
with this select i can see all users
SELECT u.lower_user_name, d.directory_name FROM cwd_user u JOIN cwd_membership m ON u.id = child_user_id JOIN cwd_group g ON m.parent_id = g.id JOIN SPACEPER
PERMTYPE='USECONFLUENCE' AND u.active = 'T' AND d.active = 'T' GROUP BY u.lower_user_name, d.directory_name ORDER BY d.directory_name;
when i try to set T to activ the user it doesn work.
can somebody please tell me where else i need to set a value?
i need it in a script, becouse sometimes to many users are activ which should not and in the frontend it takes too much time to check it.
