Re: Authorizations needed for OpsNav SQL Performance Monitor

   Not an NNTP cross-posting I guess :-)  I will post again here for 
reference by others.  Apparently a required authority is missing from 
the file; i.e. resolution should be effected by:
   GRTOBJAUT QUSRSYS/QAUGDBLL *FILE QAUTPROF *ALL

Regards, Chuck
-- All comments provided "as is" with no warranties of any kind whatsoever.

Dan wrote:
> (cross-posted on midrange-l)
> 
> I am attempting to set up a performance monitor on select jobs (on demand)
> via OpsNav's SQL Performance Monitor.  I've gotten this to work fine on our
> development box, but our production box is more secure, and when I try to
> set the "schema for the saved data", I get an error that tells me that I'm
> not authorized: "Not authorized to object QAUGDBLL in QUSRSYS type *FILE."
> A DSPOBJAUT on this object shows that *PUBLIC has only *USE authority.  (Not
> sure why this isn't "enough" authority for OpsNav.)
<<SNIP>>

_______________________________________________
This is the Security Administration on the AS400 / iSeries (Security400) mailing list
To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/security400
or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/security400.