Access a shared database using different credentials

Lee Pang

• October 07, 2017 07:03

Using a plugin, I need to move documents from a local database to a protected folder in a shared database.  The protected folder can only be written to by either an admin or service account user that has different shared database credentials as the current user.

Is it possible to access a shared database from within a plugin using a different set of login credentials than the current user?

0

• 

  Matthew Cheung

  • October 24, 2017 00:19

  Hi Lee,

  Sorry for the late reply.  I thought I had posted a reply two weeks ago but it turns out I must not have.

  Unfortunately I think what you want to do is not really possible... at least not nicely.

  It is theoretically possible to connect with different credentials programatically but the service would then appear (even if momentarily) to the user and they could inadvertently modify folders that the service account has access to which is probably not what you want.

  If you elaborate more on why you would like to do this, then perhaps I could suggest an alternative.

  Cheers,
  Matthew

  0

Please sign in to leave a comment.