I have an app with a custom login form. The connection string contains the username. However, whenever I execute a statement (or even return a recordset of "SELECT user", I get back "dbo" instead of the user name. I have some triggers setup that populate an activitylog to track changes made. However, even though I am logging in as "TestUser", the SQLServer user value comes up as "dbo". What am I missing??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB & SQL User Info
- Thread starter ScottAW
- Start date
Similar threads
