Store logon userID to all app Databases

Dear all,

I am trying to get the user-id from security provider , and store it in several app DBs. The idea behind that is that i have a user , the user create teams and i want to reference all teams with users.

My implementation so far was to store the security provider id to a Global server side session variable , and to use it in another page (Team Creation) to post the Global value to insert a record in the teams DB.

I didn’t manage to make it work.

Can you please provide my the best practices to make it work.

Regards

Antony