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

Collapse
2: Re: Banning a user via database (response to 1)
Posted by Matthew Coupe on 03/22/13 12:45 PM
Hi,

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?

Thanks

Collapse
3: Re: Banning a user via database (response to 2)
Posted by Victor Guerra on 03/22/13 02:00 PM
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.

Collapse
4: Re: Banning a user via database (response to 3)
Posted by Dave Bauer on 03/22/13 03:05 PM
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'