• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Not authorized to Object

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Not authorized to Object

    We have two different instances with two different library lists.
    The file in question in both instances has *PUBLIC *EXCLUDE.
    Yet, when a field is updated in instance #1, it updates fine (this is the desired behavior).
    However, for instance #2, we get "SQLERROR. Checking Statement handle... SQLSTATE = 42501 Native Error = -551 Message = "Not authorized to object WNPXSPSDL in MD_TEST20 type *FILE."".
    There has to be some behind-the-scenes setting which allows an update against a *PUBLIC *EXCLUDE file in instance #1 but not in #2....
    Where do I need to look?
    Thanks!
    Matt

  • #2
    We spoke to somebody else at your office about this and determined this is related to a custom authority process run against the objects in each instance.

    Comment


    • #3
      That is what I suspect, but I'm trying to track down where that happens. Is there some sort of logging in Valence that would point me in the right direction?

      Comment


      • #4
        Not for something like this, other than what you see in the Errors application. It has to do with program object authorities. Talk to your colleague - I believe he found a CL program that applies overrides.

        Comment


        • #5
          So, you think the CL program was something my colleague created versus him utilizing a Valence program to implement the file override?

          Comment


          • #6
            PS. The reason I am inquiring is because this colleague is no longer with the Company.

            Comment


            • #7
              Yes, I believe he created a CL program to (re)adjust certain program object authorities after each upgrade.

              Comment


              • #8
                Thank you.

                Comment

                Working...
                X