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:
- Role – mapping table
- Tables / Columns that need to be updated with Resource ID fields
- Tables / Columns that need to be updated with Role Code fields
- Tables that will need to be deleted
- PRTEAM table should be checked
Download Details
RegoXchange Content ID: EX0238
Submission Date:
Submitter:
Content Type: Technical Tricks
Related Modules: Administrative Support
Company: Rego Consulting
Version Support
Versions Supported: 15.x, 16.x+
Special Instructions
Special Instructions: The only safe method to remove a role is to first map any reference to that role to another role that will not be removed. This will maintain the integrity of the database pointers and the project plans by mapping the references to that role before the role is removed. The role mapping can be imported to a table within the Clarity database. Because of these challenges, we do not recommend this technical trick without help from Rego Consulting. We estimate 20-30 hours of support.
