Groups > DB2 > DB2 on AS400 server > Re: Error in iSeries Navigator




Error in iSeries Navigator

Error in iSeries Navigator
Mon, 28 Jan 2008 10:29:51 EST
When I try to view the schemas within the naviagtor I get the error message,
"<a
href="http://www-128.ibm.com/developerworks/forums/">SQL0051</a&
gt; Not authorized to object QAUGDBLL in QUSRSYS type *FILE"<br />
<br />
Post Reply
Re: Error in iSeries Navigator
Tue, 29 Jan 2008 14:50:40 -060
   The authority error is SQL0551.  The APAR SE26496 and the discussion 
thread http://archive.midrange.com/midrange-l/200705/msg01034.html give 
some more detail about that error message and that file.  That TABLE 
must be fully authorized to both the /functional/ user QAUTPROF [i.e. 
AUT(*ALL)], and authorized for read to the user accessing the function 
[i.e. AUT(*USE).

  Object . . . . . . . :   QAUGDBLL
    Library  . . . . . :     QUSRSYS
  Object type  . . . . :   *FILE
  Owner  . . . . . . . :   QAUTPROF

                             Object
  User         Group        Authority
  *PUBLIC                   *USE
  QAUTPROF                  *ALL

Regards, Chuck
-- 
  All comments provided "as is" with no warranties of any kind 
whatsoever and may not represent positions, strategies, nor views of my 
employer

mwagoner@wildflavors.com wrote:
> When I try to view the schemas within the navigator I get the error
> message, SQL0051 "Not authorized to object QAUGDBLL in QUSRSYS type
*FILE"
> What access do I need to tell the administrator I need?  Is there some
Post Reply
about | contact