Security View Cleanup

BusinessPlus uses views to enforce database security. However, the software does have logic to clean up those views. A number of unforeseen events can lead to a security view being essentially untracked or "orphaned" in the BusinessPlus database. To help create a consistent mechanism for identifying and cleaning up those orphaned views, the Security View Cleanup plugin was added to the Administrative Console (Database Admin > Utilities).

When the plugin is launched it displays an informational screen explaining the types of views being used by the software.

The Statistics tab offers statistical view information about the number of security views in the database and whether or not these views may be orphaned. To load the statistics information, click the "Refresh Statistics" button on the toolbar.

Total Views: The total number of views found in the BusinessPlus database that were most likely generated by the software based on the known naming convention.
Orphaned Views: The number of views that have been identified as orphaned based on their known tracking information. 7i Security Views are not part of this number.
CDD Security Views: The number of views currently in the database that were generated by CDD to enforce security.
CDD Security Views marked for Reuse: The number of the CDD security views that are marked to be dropped and recreated when that line in bsi_sec_views for that user is reused by the software. Rebuilding security does not drop these views but simply sets the as_of date in the table to null. The view remains in the database until that particular security item is processed later.
Orphaned CDD Security Views: Those views that were identified as CDD Security views based on their name but are not currently tracked in bsi_sec_views.
CDD Design Views: Those views that were created by CDD for catalog views. CDD removes these when properly shut down.
Orphaned CDD Design Views: It is assumed that any design view older than seven days is orphaned.
Total Classic Security Views: The number of security views created by the software running on the Application server.
Classic Security Views marked for Cleanup by 7i: When user security is rebuilt, the existing Classic Security Views are marked as inactive and are left on in the database in case a process on the Application server is still using them. The Data Processing Service then cleans up the inactive Classic Security Views as part of scheduled maintenance.
Orphaned Classic Security Views: Those views found to be Classic Security views based on the naming convention that are not currently being tracked as active or inactive.
Total 7i Security Views: The total number of views found in the database based on the naming convention that are believed to have been created by 7i Data Processing Services.
7i Security View Aging: This list shows the number of Security Views older than 1 year, 90 days, 60 days, 30 days, 15 days, and 7 days. Realistically, any views older than the last time you restarted Data Processing Services on the 7i servers are most likely orphaned. However, it is recommended that you do not drop the views unless they are older than 7 days. Dropping security views that may still be in use by 7i servers will cause errors in the 7i software and will most likely result in having to restart Data Processing Services on affected servers.