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

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'