Pass tenant id via sql server connection

Posted by Alexey Zakharov on Stack Overflow See other posts from Stack Overflow or by Alexey Zakharov
Published on 2010-05-20T11:10:32Z Indexed on 2010/05/20 11:40 UTC
Read the original article Hit count: 257

Filed under:

Hi guys,

I'm building multi tenant application with shared table structure using Microsoft SQL Server.

I wonder if it possible to pass tenantID parameter via sql server connection. I don't want to create separate user account for each tenant.

Currently I see two ways: via ApplicationName or WorkstationID

Best regards, Alexey Zakharov

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about multi-tenant