Re: Authorizations needed for OpsNav SQL Performance Monitor

[CRPence <crp@xxxxxxxxxxxxxxxxxxxx>]

  Seems the necessary authority is missing for the functional profile 
for the feature.?  Grant the expected authority of *ALL to the user 
QAUTPROF for the noted file; i.e. GRTOBJAUT QUSRSYS/QAUGDBLL *FILE 
QAUTPROF *ALL
  There is a seemingly similar, but unrelated error documented on the 
IBM support page; in case someone might redirect to the APAR= SE26496
  http://www.ibm.com/systems/support/i/databases/index.html

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

Dan wrote:
> 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.)
>
> Anyway, before I go bugging the sysadmins to change the authorization on
> this particular object, it would be nice to know if there are other objects
> that SQL Performance Monitor uses that are impacted by *PUBLIC/*USE
> authority.  Anybody know?
>
> FWIW, servers are at v5r3 and OpsNav is at v5r3.
>
> TIA,
> Dan