I need to edit the job titles of users in an installation of WSS 3.0. There doesn't seem to be an easy way of doing this as an administrator. Users can edit their own details via the _layouts/useredit.aspx link. But I need to do the update for all users myself.
I was thinking of doing a global update by writing a SQL script to update the relevant fields in the DB.
I can access the WSS database tables via SQL Server Management Studio Express. There is a table named dbo.UserInfo which seems to hold the users details (Name, Email) but this doesn't hold the Job Title info.
Does anyone know where in the DB the Job Titles are stored? Or how I can go about updating the Job Titles another way?
Thanks in advance. Nigel