Multi Tenant Database vs System prompt

[Namec999]

Hello,,

Currently doing my tests with this great piece of software.

My use case : having wren that expose an api endpoint to my users, and these users have a unique ID to retrieve their own data (have an ms sql multi tenant database)

My question : how to add the user ID to my prompts or any other Auth mechanism to achieve my goal, and make the endpoint retrieve only users Data .

Best.