AnsweredAssumed Answered

Stored Procedure call From AF return [-10407] No Access - Secure Object

Question asked by RogerObis on Apr 27, 2018
Latest reply on Apr 30, 2018 by gregor

Greetings,

I'm trying to call a secured procedure from an external database with an AF Table. But getting a [-10407] No Access - Secure Object.

  • I tried the same procedure but without securing it and was a success.
  • The PiServer have a trust with the external database.
  • The user specified in the table connection have the correct rights to execute that procedure.
  • The secured procedure works fine in the external database with the same user but not in the AF.

It's possible that the credentials to open the secured procedure were lost in the process from AF to SQL?

 

Thanks in advance, all help is well recieved

Outcomes