set activ-user with querry

[Bart]

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.