Re: Looking for a utility to change PUBLIC authority for most objects in a library

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Charles,

For a one time change you could create a PDM option to dspobjaut to an
outfile and read that in a CL or with the run sql statement option of
Operations Navigator. If you use operations navigator you can generate
something like:

select 'CL: chgobjaut obj(' || trim(object.library) || '/' ||
trim(object.object) || ') objtype(' || trim(object.type) || ')
user(*PUBLIC) aut(*EXCLUDE) replace(*YES);' from outfile/lib where...

Cut and paste these results into the top pane and run them.

--David Morris



>>> CWilt@xxxxxxxxxxxx 03/02/05 2:38 PM >>>
All,

Basically, I've got some libraries where a significant number of
objects such as programs and commands currently have *PUBLIC authority
of *ALL.  (Note: I didn't set it up, I just inherited the mess ;-)

What I need to do is change these objects to *USE.

The tricky part is some objects have been set *PUBLIC *EXCLUDE.  These
*EXCLUDE objects should not be changed, so I can't just globally change
every object in the library.  Additionally, there are some objects, such
as data queues that need to be changed from *ALL to *CHANGE instead of
just *USE.  I'll need a way to make sure I change any "data" type object
from *ALL to *CHANGE instead of *USE.


I figured before writing my own utility, I'd see if anybody had already
done this.

I'd appreciate any guidance or code anyone would be willing to share.

Thanks,

Charles Wilt