4. Upgrading Using Unload/Reload : How You Perform an Upgrade Using Unload/Reload : Check for Obsolete Users
 
Share this page                  
Check for Obsolete Users
Old databases may have objects created by users who no longer exist. Check for obsolete users for each database.
To check for obsolete users:
1. Examine the scripts created by unloaddb in the step Run Unloaddb of the upgrade procedure.
Each script contains set session authorization SQL statements for each user who owns a database object.
2. Search for the set session authorization statements, and make sure that all users listed are valid.
3. Delete all the lines from the unwanted set session authorization statement up to the next one, if obsolete users are found.
4. Go into the database and clean out these unwanted objects.