Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

User Anonymization

You can now anonymize users. The user ID linked to all records in the database will be an automated anonymous ID.

If upgrading, a user anonymization procedure can be used in order to anonymize all existing users. The procedure creates a new user, where user_id is created with anonymous user ID starting with US prefix (retrieved from app.ids) and the old user ID is inserted in new column user_name. All other information for the user remains the same. The procedure also assigns the same authorities to client, roles, organization, and templates as the old user. In addition, all existing tables are looped and updated with the new user ID. Thereafter, the old user is set to inactive.        

To anonymize one user, run the procedure utils.p_anonymize_user. To anonymize all users, simply create a cursor and repeat the procedure for all users.

When creating a new user, the user ID will be auto-generated with an anonymous ID and, instead, a user name should be defined, which the user uses when logging in.        

A new column is created in the Users grid, showing the new column user_name from app.users:  

     

Published:

User Anonymization

You can now anonymize users. The user ID linked to all records in the database will be an automated anonymous ID.

If upgrading, a user anonymization procedure can be used in order to anonymize all existing users. The procedure creates a new user, where user_id is created with anonymous user ID starting with US prefix (retrieved from app.ids) and the old user ID is inserted in new column user_name. All other information for the user remains the same. The procedure also assigns the same authorities to client, roles, organization, and templates as the old user. In addition, all existing tables are looped and updated with the new user ID. Thereafter, the old user is set to inactive.        

To anonymize one user, run the procedure utils.p_anonymize_user. To anonymize all users, simply create a cursor and repeat the procedure for all users.

When creating a new user, the user ID will be auto-generated with an anonymous ID and, instead, a user name should be defined, which the user uses when logging in.        

A new column is created in the Users grid, showing the new column user_name from app.users:  

     

For an optimal Community experience, Please view on Desktop
Powered by Zendesk