Re: Can the current session be notified and refreshed with a new credentials context?

Ron <ronljohnsonjr@xxxxxxxxx> · Mon, 22 Jun 2020 16:21:19 -0500



    On 6/22/20 4:07 PM, AC Gomez wrote:

    
      Suppose you have the following scenario:
        

        1: Call some function with a certain user and password
        2: From inside that function, have several calls using
          DBLink
        3: At some point during the running of that function a
          password rotation(a separate process) comes along and
          updates the session user password and the User Mappings with
          this new rotated password
        4: Now there is a discrepancy between the password used
          when the session started and the password in the User Mappings
        5: The result is that on the next DBLink call the main
          function will fail because the session is still running with
          the old password but we have changed the User Mappings.
        

        We have proven this by separating out every DBLINK call as
          its own new session and running password rotation in between
          dblink calls. Then things will work.
        

        My question: Is there a way to update or refresh the
          session with the new password that was rotated so that the
          main function keeps running seamlessly through all it's DBLink
          calls?
        

        If something like this is not available, then password
          rotation can only run when nothing else is running.
      
    
    I've not seen such a thing on any system.

    
    -- 

      Angular momentum makes the world go 'round.