Hi colleagues,
If you need to update the User form in bulk mode, you might need to do it on DB level. This is the case especially if number of your users exceeds the value which is configured in Max Entries Returned by GetList parameter in Server Information form.
As an example, you might need to remove duplicate permissions from users. If this is what you need to do, you also need to update the "user_cache" table besides "user_x" (DB table for User form) because ARS will not recognize your update since it is a DB level update. However please be careful when you update esp. user_cache table because ARS uses this table on-line and you can easily have your user data corrupted if you make an incorrect update. Following are very basic queries how you can update a user's permissions:
-- user_x update
update user_x
set group_list = ';15001;'
where username = 'test_user'
-- user_cache update
update user_cache
set shortgroup = ';15001;'
where username = 'test_user'
Please note that "user_cache" and "user_x" has different table structures.
Other than User form, Group form also have this structure on DB, means there is group_cache table.
Have a sunny day!
