Post

1 follower Follow
0
Avatar

Access a shared database using different credentials

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?

Lee Pang

Please sign in to leave a comment.

1 comment

0
Avatar

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

Matthew Cheung 0 votes
Comment actions Permalink