NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: JohanR on October 04, 2011, 03:08:43 AM

Title: DBowner - Muliple DB's, mulitple users
Post by: JohanR on October 04, 2011, 03:08:43 AM

Hi,

On startup of web site, user would log in, this data would be in the main DB
using his login details I would check which company he belongs too,
then I would want to set the dbowner to his specific company DB.

My thinking is along these lines.

If the user dbowner is not set in the session queue, then set dbowner to main db, pop up the login screen,
else set to dbowner that is in the session variable?

thanks for any tips or advice

Johan

Title: Re: DBowner - Muliple DB's, mulitple users
Post by: kevin plummer on October 04, 2011, 06:57:02 PM

I do a similar thing...

But I set the SSV DB Owner every time the user logs in as my users can have access to more than 1 DB which they can pick from a filtered drop list on the login screen. If they don't have access to more than 1 then I don't show the drop list of DB's

Then in the ProcessLink embed in the web handler I set the Glo:DBOwner to the GSV db Owner and as you say, if the SSV does not exist because the user has been logged out then popup the login screen.