Re: GRTOBJAUT...does anyone know
Rob Berendt <[email protected]>
| Newsgroups | gmane.comp.hardware.ibm.midrange |
|---|---|
| Message-ID | <CAPJ+qQO8zOoir2hxHRqj3G7uX+mQ0J2mnzQYgtu2DOKA6ktEBQ@mail.gmail.com> |
I believe it would try to change it for all and not just those changed ones. A test library with just a few objects might be a confirmation. Retire CL for this thought. Think SPL or Stored Procedure Language instead. See if you can use - A SQL service to retrieve existing security settings. - Pump that with QCMDEXC (either the scalar function or the procedure if you write a whole procedure) Think a combination of OBJECT_STATISTICS and OBJECT_PRIVILEGES as shown at: https://www.ibm.com/docs/en/i/7.6.0?topic=optimization-i-services I'd have more comments, but you did say "please"... On Mon, May 11, 2026 at 9:12 AM <[email protected]> wrote: > We are in the process of cleaning up / tightening up security on our > production machines. > > > > One of the many libraries has about 8,000 objects in it and all but about > 100 have the correct authorities. If I do a GRTOBJAUT for *ALL objects in > the library, does anyone know if the command is smart enough to only look > at > and only adjust the objects that do not have the particular supplemental > group or does it try to adjust all 8,000? I'm trying to figure out if it > would be more efficient to build a CL with just the objects that are > problems. > > > > And please do not suggest using authorization lists. I'm working toward > that but trying to get a handle on why the authorities are what they are > (and that would politely be called "a mess") has been like trying to turn a > barge with an oar. I'm slowing getting there but is it taking forever so > we > are taking an intermediate step first. > > > > > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: [email protected] > To subscribe, unsubscribe, or change list options, > visit: https://lists.midrange.com/mailman/listinfo/midrange-l > or email: [email protected] > Before posting, please take a moment to review the archives > at https://archive.midrange.com/midrange-l. > > Please contact [email protected] for any subscription related > questions. > > -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/midrange-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact [email protected] for any subscription related questions.