Multiple user credentials in one library

[John_Wick]

Hello, experts!

Has anyone encountered the need to use one library for different users? Could you please advise if this can be realised using the regular Managemnet Console apparatus (not using autoexec custom, but using User manager)?

For example, there is a TEST library and two users: TEST_USER1 and TEST_USER2. Each user has a different set of permissions on objects at the database level.
We want to have one library in the Management console, but depending on the current user (groups he/she is a member of) when using it on Stored Process Server, Pooled Workspace Server and Workspace server, the connection string to the library includes either credentials of TEST_USER1 or TEST_USER2.

[Patrick]

I believe you're looking for How to Store Passwords for a Third-Party Server