List and changing object owner with SQL Simon Hutchinson

​At my work one of the things that auditors look for is who owns all the objects in the production libraries. If there are objects that do not belong to the expected user profile then they want an explanation of why they do not. The week before the auditors are due I do a “scan” of all the production libraries, I am responsible, for to look for any objects that do not belong to the expected user profile, it’s better to be prepared than be surprised by the auditors.
Fortunately I can perform the “scan” of all those libraries at once with a SQL View, OBJECT_OWNERSHIP, to return a list of objects that do not belong to the expected user profile.
For the purposes of this post I am going to limit my examples to the objects in my personal library, MYLIB. And I am only interested in a few of the columns of this View:
Read more » Read More 

Display event – IT Leadership Series: Generative AI – Pros and Cons

​Join COMMON and industry security experts, Jeff Crume, Ph.D, IBM Distinguished Engineer, and Carol Woodbury, President and CTO of DXR Security, to examine the good and the bad of Generative AI, like ChatGPT, and address security concerns that should be top-of-mind for all organizations running IBM i.
Jeff Crume is a Distinguished Engineer, Master Inventor and CTO for IBM Security Americas with more than 40 years’ experience in the IT industry. Read More 

Workshops

​Take a giant leap forward in modern IBM i development skills with your choice of in-depth workshops!
Choose from these half-day online workshops to master modern IBM i skills. Read More 

Verified by MonsterInsights