Using IBM i Services to Manage Owned Objects
Gain flexibility by using these IBM i Services to manage owned objects.
I recently had a client that had a set of profiles that shouldn’t have any owned objects but did. In this article, I describe how I used IBM i Services to get more information about these objects so we could determine what do to with them (that is, delete or reassign ownership).
Step 1: Discover the Scope of the Problem
We ran into this situation when we went to delete one of the profiles belonging to someone who had left the organization. We couldn’t delete the profile because it owned objects. Because this profile owned objects, I wondered if there were others. Rather than run the Work with Objects Owned (WRKOBJOWN) command for each profile, I decided to use the following SQL to find the list of profiles that owned objects…