Edit Activation Password/Expiration via SQL?

[zooyorq]

We have a BES Server who's BAS-AS service has completely crapped out. Spent hours trying everything to get it to work, getting no where. I have a user who needs to have their new blackberry activated. They're already in the BES server, I just need to change the activation password and set the expiration.

I imagine this should be easy to do via SQL Studio Manager .. I poked around in the tables and didn't see anything obvious in any of the *user* tables.. its possible its a separate table that references their user id #.

Does anyone know where I could set the activation password and expiration? Which table? Hopefully the password doesn't need to be encrypted in the database.