Role Removal

In many instances, having excess information stored within the database can cause poor performance or slowness when retrieving data. Administrators are always seeking out ways to clean and remove unused information. This technical trick on role removal provides the steps necessary to remove roles that would otherwise be unused and eliminating unwanted information.

The Role Removal Technical Trick provides the information for the creation of the following tables and columns which are necessary to perform the role removal:

1. Role – mapping table
2. Tables / Columns that need to be updated with Resource ID fields
3. Tables / Columns that need to be updated with Role Code fields
4. Tables that will need to be deleted
5. PRTEAM table should be checked