Forum .LRN Q&A: Re: Banning a user via database

Posted by Matthew Coupe on

I was wondering if anyone had any ideas on how to do this?

We need to disable 1,000s of user accounts and we're not sure of the best way to do it?


Posted by Victor Guerra on
Do you need to do it strictly from the database?

What about just writing a tcl script that calls the tcl proc acs_user::ban? it takes simply as parameter the user_id.

Posted by Dave Bauer on
You need to update the membership_rels table member_state column to 'banned'.

You'll need to select the rel_id from the acs_rels table based on

object_id_one = acs__magic_object_id('registered_users')

object_id_two = user_id you want to ban

rel_type = 'membership_rel'