sql to help find who owns objects

Created by Brenda Gardner, Modified on Wed, 7 Aug, 2024 at 10:03 AM by Shawne O'Connor

Came across this SQL to help find who owns objects:

Can someone write up the American issue and attach this note, please. It may be helpful to uncover. I don’t understand how that user is ‘owning’ objects.

select * from qsys2.object_ownership

where authorization_name = 'METAL '

order by object_library, object_name, Path_name

Lisa Hauf

To Change objects ownership:

Use CHGOBJOWN and prompt
AUTSLJM1
Library - MODAMERICN

Obj Type - *FILE (or whatever the object is)
ASP *
New Owner - AMERICAN

Current Owner authority - *REVOKE